Using SQL Server 2000 and Access 2003
I want to convert the database from access to sql Database.
There is possibility in sql server 2000 or any other tools is available.
Need Help
A:
In Access there is a Database Upsizing Wizard that will create a SQL Database and import all your data.
idstam
2009-09-29 10:41:30
The SSMA tool from the SQL Server tool appears to be consideribly better than the Upsizing Wizard.
Tony Toews
2009-09-29 20:21:28
@Tony: Have you compared the SSMA results to simply exporting the table directly to the ODBC database?
David-W-Fenton
2009-09-30 02:55:08
Didn't know about SSMA I used the Access way about ten years ago. It is one answer, but I would definitely use SSMA from now on. Thanks Tony
idstam
2009-09-30 04:45:29
+2
A:
There is a tool from the SQL Server group. SQL Server Migration Assistant for Access (SSMA Access)
Tony Toews
2009-09-29 20:21:39