Last post Feb 11, 2009 03:40 PM by Mikesdotnetting
Feb 10, 2009 05:24 PM|defyant_2004|LINK
I am in the process of migrating an Access Database to SQL Server 2000. Is the Upsize Wizard the best and only method for this?
Feb 10, 2009 06:16 PM|SBuckley|LINK
The best and easiest way to migrate your database is by using the Upsize Wizard. You will find the instructions on how to complete this process from this link: http://support.microsoft.com/default.aspx/kb/237980
Feb 11, 2009 02:53 AM|Mikesdotnetting|LINK
I found the SQL Server Migration Assistant for Access to be much better than Access's inbuilt upsize wizard:
Feb 11, 2009 10:15 AM|defyant_2004|LINK
If I understand correctly, the SQL Server Migration Assistant for Access is not available with SQL 2000. It is only available with 2005 or greater. Is that true?
Also, I intend to upsize the database tables to SQL Server and just link my access application to those tables. Minimal changes as a temporary hold until the application can be rewritten in .NET. Is there anything I should be aware of taking this approach?
Feb 11, 2009 03:40 PM|Mikesdotnetting|LINK
If this isn't an ASP.NET application, you would be better off asking in a Access application development forum.
http://www.utteraccess.com is a good one.