sql server dts: Hi,
I need to move a access 97 database to sql server 2000. What is the best way
to achieve this? Is there any upsizing wizard for the above verisons. Thanks

There is an upsize wizard but if all you want to do is take across structure
and data then you can use DTS. A very good Access developer and SQL Server
user has always said that unless your Access DB is very trivial forget the
upsizing wizard and recreate in SQL Server from scratch. A bit of time now
will save you hours later

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


[quoted text, click to view]