Migration from MS Access database to SQL Server DB

G

Guest

Hi All,

I want to create a utility for migrating MS Access DB to SQL Server DB. Can
anyone help me? I can use Upsizing wizard to migrate. But how can i capture
code(VB) or else how can i create the utility.

Please help.

Regards,
vilas relan
 
A

Arvin Meyer

There is no code in SQL-Server. It is a database engine and management
system. Access can still be used as the front-end for SQL-Server, as can VB,
a thin client, or any of the programming languages that can produce a form
or report. Since Access is uniquely suited to database creation, and you
already have the code written, it is probably the best tool for that
migration.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server Migration Assistant... 2
Access 2007 and connecting to SQL server 2008 6
how to migrate from ms access to sql server 1
upsize to sql server 6
Upsizing wizard failures 3
Split Database vs. Access Project 3
Vista OS, Access DB, ODBC Sql Server, Date Error 3
Moving Access DB to MS-SQL Server 3

Top