Converting MS-Access to MS-SQL Server

Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
You can use the Access upsizing wizard (not recommended because it
creates a lot of junk of the server that you have to clean up). You
can also use DTS (or SSIS in SQLS 2005), but then you have to create
keys, indexes, etc. The other option you should seriously consider is
that this is a golden opportunity for rewriting the database schema to
optimize it for SQL Server. SQLS is not just a bigger Jet--it's a
completely different RDBMS. Migrating the data is the least of the
issues involved.
--Mary
On Sat, 21 Jan 2006 17:45:02 -0800, "Jack"
<Jack@.discussions.microsoft.com> wrote:

>Hello all,
>I got a application which is developed using VB6.0 as front end and
>MS-Access as backend. Now i would like to change the database from MS-Access
>to MS-SQLserver.
>How do I change the databse from MS-Access to MS-SQLServer?
>Regards
>Jack