Entry

Database:Microsoft SQL server:Import: How convert Microsoft Access database to Microsoft SQL server?

Mar 25th, 2005 10:37
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 14 December 2003 - 11:41 pm -------------------

Database:Microsoft SQL server:Import: How convert Microsoft Access 
database to Microsoft SQL server?

---

Steps: Overview:

 1. -Open the program 'Microsoft SQL server Enterprise manager'
     in your Microsoft SQL server directory

 2. -Select the database group in which you want to import
     in the left pane

     (so you have earlier created this database group) in the left pane

     e.g.

      'Microsoft SQL Servers'->'SQL Server Group'->'(local) (Windows 
NT)'->'Databases'

 3. -select from menu option 'Action'

     1. -select from list 'All tasks'

        1. -select from list 'Import Data...'

 4. -This will start the database conversion wizard

     1. -Click button 'Next'

     2. -Choose a 'Data Source'

         1. -Select 'Microsoft Access'
             from list 'Data Source'
             (you should choose the entry
              with the 'yellow key' icon,
              and thus not a driver)

         2. -Choose a file name

             1. Browse by clicking on '...'

                1. Select a file on your computer
                   or network
                   (thus with extension .mdb)

                   e.g.

                   H:\pdrive\radius\WinRadius.mdb

     3. -Click button 'Next'

         1. Possibly create a new database name in Microsoft SQL Server
            in which to store that Microsoft Access database

            1. -Select from list '<New>'
                in the field 'Database'

               1. Type a name

                   e.g.

                    mydatabasename

            2. -Click button 'OK'

     3. -Click button 'Next'

     4. -Click button 'Next'

     5. -Enable checkboxes of tables you want to convert

         1. -Possibly select the correct order if foreign keys

     6. -Click button 'Next'

     7. -Click button 'Next'

     8. -Click button 'Finish'

     9. -You should then see a message box showing:

         'Successfully copied ... tables from Microsoft Access to
          Microsoft SQL Server'

 5. -Possibly restart 'Microsoft SQL server Enterprise manager'
     to see the converted database

----------------------------------------------------------------------