|How do you convert Access table to SQL table?
|| Postado em 26/10/2005 07:14 por yiukori
|I want to create a SQL table on a SQL server that have the same information as the MS Access table. Does anyone have any idea of how to use DBManager Professional to do that convertion?
Any help will be greatly appreciate!
|Re: How do you convert Access table to SQL table?
|| Postado em 27/10/2005 09:40 por support
You can achieve this in 3 different ways, but for all of them you will need the DBManager Enterprise Edition.
1) Using the MSDAO Import Wizard:
a) Connect to the MSSQL Server
b) Create an empty database which will be the mirror of the MSAccess db
c) Start the Wizards Manager and choose the DAO Import Wizard
d) Fill all the data required
e) At the end of the process you will have an MSSQL Server database with the same structure and data (if you chose to) as MSAccess db
2) Using the Migration Wizard:
a) Connect to MSSQL Server
b) Create a new MSAccess Server with Server Manager
c) Attach the MSAccess database you want
d) Start the Wizards Manager and choose Migration Wizard
e) Follow the steps in the wizard
3) Using Drag and Drop
a) Connect both MSSQL Server and MSAccess
b) Select the Objects View
c) Select the MSAccess database=>Tables item
d) Drag all tables you want to the MSSQL Server database
e) This will start the migration wizard to let you choose information that will be imported/converted
Hope that helps,
Support / DBTools Software