Upsizing ACC 97 to SQL 2000

[Guest]

What is the best tool to use to upsize an Access 97 database to SQL 2000?
The upsizing wizard in Access97 doesn't seem to work with SQL 2000, and the
SQL Server Migration Assistant for Access doesn't seem to work with anything
older than SQL 2005.

Is there something that is kinda like the Migration Assistant for SQL 2000?
If so, where do I find it? Or, how can I do an upsize if I don't have an
Access version later than 97?

 

[Tony Toews [MVP]]

What is the best tool to use to upsize an Access 97 database to SQL 2000?
The upsizing wizard in Access97 doesn't seem to work with SQL 2000, and the
SQL Server Migration Assistant for Access doesn't seem to work with anything
older than SQL 2005.

Download and install the SQL Server 2005 Express on your system. Use
the SSMA as it doesn't depend on Access.

Then see the Data conversion section at the Random Thoughts on SQL
Server Upsizing from Microsoft Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm to create a
script which you can then run on SQL Server 2000. Note that various
functions in SQL Server 2005 will be named differently than SQL Server
2000 but you should get the idea.

Chances are a few dates are not in this or the previous century. SQL
Server's standard date format covers a much smaller range. I
misremember the date range exactly.

What can be quite misleading is if someone keys in an extra digit.
Access interprets that digit as a century. However as most computers,
not mine I assure you, are set to only display 2 digit years no one
would ever notice this.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/