Answered by:

Conversion from Access 2003 to sql server 2005

Question

Hello, I have an exiting project in visual basic 6.0 and access 2003.now i want to use the latest technology so i decide to convert the back end to sql server 2005 and front end to asp.net.My question is that i searched many conversion tool but most of
them are just converting data table.I want to convert access table,forms,query,reports,macro etc..into sql server triggers,views,functions,procedures etc..automatically. Is there any conversion tool to convert the database? Please let me know.

Answers

As Jeff Wharton pointed, you can import the Access tables into SQL Server database by using Upsizing Wizard. Moreover there are two more options for you such as Linked Server and OPENDATASOURCE. There are other options which might help you to convert Access
database to SQL Server 2005 database as well. If you want to use import / export wizard or SSIS methods, please refer to the details as below:

• Use the import / export wizard to convert MS Access tables to SQL Server. Please follow the steps in this
article.

As Jeff Wharton pointed, you can import the Access tables into SQL Server database by using Upsizing Wizard. Moreover there are two more options for you such as Linked Server and OPENDATASOURCE. There are other options which might help you to convert Access
database to SQL Server 2005 database as well. If you want to use import / export wizard or SSIS methods, please refer to the details as below:

• Use the import / export wizard to convert MS Access tables to SQL Server. Please follow the steps in this
article.