Re: Converting MS-Access to MS-SQL Server
- From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 23 Jan 2006 08:53:37 -0800
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@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
.
- Prev by Date: Re: SQL Server 2005 Express Native client driver
- Next by Date: Output !
- Previous by thread: SQL Server 2005 Express Native client driver
- Next by thread: Output !
- Index(es):
Relevant Pages
|
Loading
