Upsizing to SQL 2000

[Big Time]

I have an Access 2000 DB that I've been considering upsizing to SQL Server
2K. I'm wondering if anyone can share their experiences in upsizing and let
me know of any tips or pratfalls. I've been playing around with the upsize
wizard however not all of my tables have properly converted. None of the
primary keys transfer (I understand this is a limitation) and the whole
thing hasn't really worked the way I thought it would. I have tried
importing the data using DTS from SQL Server which has been more successful
however now I'm considering whether it's even worth upsizing to SQL.

What I'm looking for is some advice from people who have gone through the
process about how smooth the transition was, and whether it worked out as
planned. The DB I'm working on is an educational database, approx 80,000
records and would ultimately have 30 - 40 users max (and on most times no
more than 5 - 10 users). Part of the reason I'm thinking about upsizing is
to put the DB online to allow for dynamic updates and web access.

Thanks for any advice.

Mike

[Tony Toews]

"Big Time" <bi************@remove-for-spam-hotmail.com> wrote:

I have an Access 2000 DB that I've been considering upsizing to SQL Server
2K. I'm wondering if anyone can share their experiences in upsizing and let
me know of any tips or pratfalls.
Do a search at the Knowledge Base at support.microsoft.com using the keywords
"upsizing" to review the various white papers on upsizing Access to SQL Server as
well as to ensure you have any updates required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm
I've been playing around with the upsize
wizard however not all of my tables have properly converted.
Likely due to a few dates outside the SQL Server small date/time format. See the
above page for more details.
None of the
primary keys transfer (I understand this is a limitation)
Eh? They should've transferred just fine.
and the whole
thing hasn't really worked the way I thought it would. I have tried
importing the data using DTS from SQL Server which has been more successful
however now I'm considering whether it's even worth upsizing to SQL.

Yup, DTS would likely work better.

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

[Edward]

Tony Toews <tt****@telusplanet.net> wrote in message news:<d9********************************@4ax.com>. ..

"Big Time" <bi************@remove-for-spam-hotmail.com> wrote:

I have an Access 2000 DB that I've been considering upsizing to SQL Server
2K. I'm wondering if anyone can share their experiences in upsizing and let
me know of any tips or pratfalls.

Do a search at the Knowledge Base at support.microsoft.com using the keywords
"upsizing" to review the various white papers on upsizing Access to SQL Server as
well as to ensure you have any updates required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft Access Tips page at
http://www.granite.ab.ca/access/sqlserverupsizing.htm

I've been playing around with the upsize
wizard however not all of my tables have properly converted.

Likely due to a few dates outside the SQL Server small date/time format. See the
above page for more details.

None of the
primary keys transfer (I understand this is a limitation)

Eh? They should've transferred just fine.

and the whole
thing hasn't really worked the way I thought it would. I have tried
importing the data using DTS from SQL Server which has been more successful
however now I'm considering whether it's even worth upsizing to SQL.

Yup, DTS would likely work better.

I would concur with this. DTS is a great tool (well, pretty good) and
much more flexible than the upsizing wizard.

Edward
--
The reading group's reading group:
http://www.bookgroup.org.uk