Upsizing Problem with number of records

[jmillerWV]

I am attempting to upsize an Access 2k3 database to SQL 2000. ( this is what
is in Small Business Server 2003). When I try using the upsizing wizard It
will only import 10,000 records. My main table as well as several supporting
tables each have over 350,000 records. I have tried to upsize choosing to
connect to the current mdb instead of creating a new application, as well as
just upsizing the structure and not the data. This way works ok but only
upsizes the tables and not the queries.

1.Do I have to break down the tables into 10,000 record bunches?
2.Or is there a setting that needs changing?

I appreciate any help you can give me on this.

 

[Scott Lichtenberg]

I've never used the upsizing wizard, but there are a couple of ways around
this problem.

1. Link to the SQL table then run an append query.
2. Export the data to a delimited text file, then use the SQL Server's BCP
utility to import. BCP is designed to load huge numbers of records very
quickly. You should be able to find plenty of documentation online.

Hope this helps.

 

[Albert D. Kallal]

I moved up tables of 500,000 records without any problems.

I would suggest that you try moving up the table, and select "do nothing" to
your application....

I also found the upsizing upload process in access to be MORE reliable then
the sql server integration tools that ships with sql server 2005.

So, I would also try upchucking any of the create indexes and relationship
options also. Try uploading just the one table with no options, and don't
have the upsizing wizard do anything to your existing application...