Very new to SQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anukagni
    New Member
    • Nov 2006
    • 53

    Very new to SQL

    Hi all,

    I Know Ms Access and now i want to convert all the access application to SQL ofcourse i have download an trial version SQLServer edition and don't know how to start with.

    Is any body told me how to start and if any tutorial is possible for me to download i ill download i and i can learn..

    Please do the need full...

    bye
    anukagni
  • dswethar
    New Member
    • Nov 2006
    • 65

    #2
    Originally posted by anukagni
    Hi all,

    I Know Ms Access and now i want to convert all the access application to SQL ofcourse i have download an trial version SQLServer edition and don't know how to start with.

    Is any body told me how to start and if any tutorial is possible for me to download i ill download i and i can learn..

    Please do the need full...

    bye
    anukagni
    Hi,

    I found the MSDN that comes with SQL Server the most useful till date.

    Apart from that, there is a book that I would suggest - Professional SQL Server Programming By WROX press. It explains every little detail of SQL server for beginners.

    You might want to wait for others opinions before going ahead and buying the book. Read other reviews also.

    Comment

    • AricC
      Recognized Expert Top Contributor
      • Oct 2006
      • 1885

      #3
      Here is an article that may help you out. Are you planning on redesigning the DB or keeping the structure the same? Don't buy a book if you feel like you know SQL pretty well like ds said the MSDN can help you out a ton for free.

      Comment

      • anukagni
        New Member
        • Nov 2006
        • 53

        #4
        HI,

        I want to use redesign give me some idea

        anukagni

        Comment

        • sashi
          Recognized Expert Top Contributor
          • Jun 2006
          • 1749

          #5
          Originally posted by anukagni
          HI,

          I want to use redesign give me some idea

          anukagni
          Hi there,

          Redesign what? I assume you need an idea on migrating your existing MS-Access database to MSSQL database, hope i guessed correctly. Data migration wizard tool that comes with MSSQL Server package can be useful. Kindly check out the manuals for further reading & understanding.

          Data import, export and migration solution by DTM soft with process automation features

          Comment

          • anukagni
            New Member
            • Nov 2006
            • 53

            #6
            Yes , Ur right but i have just download the sql sever 2005 and dont know how to use it please give me some idea how to start with the basic

            bye
            anukagni,

            Comment

            • sashi
              Recognized Expert Top Contributor
              • Jun 2006
              • 1749

              #7
              Originally posted by anukagni
              Yes , Ur right but i have just download the sql sever 2005 and dont know how to use it please give me some idea how to start with the basic

              bye
              anukagni,
              Hi there,

              Please explain to me one thing, how do you expect me to help you and in which way do you expect me to help you? I've took the trouble on your behalf to look for tutorial on the above problem, by all means, please check the link for further reading & understanding, if at all help is very much needed then pls come back again. Good luck & Take care.

              Comment

              • sashi
                Recognized Expert Top Contributor
                • Jun 2006
                • 1749

                #8
                Originally posted by anukagni
                Yes , Ur right but i have just download the sql sever 2005 and dont know how to use it please give me some idea how to start with the basic

                bye
                anukagni,
                Hi there,

                Do a little research on Data Tranformation Service (DTS) for further reading & understanding. Good luck & Take care.

                p.s./ read & try to understand my signature text :)

                Comment

                • anukagni
                  New Member
                  • Nov 2006
                  • 53

                  #9
                  hi,

                  Iam SQL server and iam new for that i know access and i have finished an DB now i want to convert the back end to the SQL Server & front end in Ms Access .. What should i do..?

                  anukagni

                  Comment

                  • sashi
                    Recognized Expert Top Contributor
                    • Jun 2006
                    • 1749

                    #10
                    Originally posted by anukagni
                    hi,

                    Iam SQL server and iam new for that i know access and i have finished an DB now i want to convert the back end to the SQL Server & front end in Ms Access .. What should i do..?

                    anukagni

                    Comment

                    • tomarvijay80
                      New Member
                      • Nov 2006
                      • 10

                      #11
                      You can download of SQL Server from www.microsoft.c om or search for the book in google as SQL server book 2000. SQL server is very user friendly. If u have an experience on working with access u can easily learn SQL Server.

                      Comment

                      Working...