Question Locked

Any way to import to sql 2005 w/out upsize wizard from Access 2000 or 2003

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm trying to solve a problem in which I have a currently set up database with relation ships and processes and ect. My problem is the data is old and I need to completly clear the records and bring in new data. So far what I found to do this task hates the relationships and tries to write to the primary key causing failed imports.

Anything that I can add to my list to try with an import/purge.

I have sql 2005 with access 2000 database.

2 replies

by tony hopkinson

In SQL Server Management Studio Select your database, right click, select Tasks, selct import data and it will put a wizard up.

Probably too late now, but my preferred option with this sort of job.

Is to do a 1 - 1 copy from a source tp SQL Server, absolute minimum of conversion.
Then Write a script to create a new data base with the schema and insert from the copy, then you just keep battering away dropping the new version, recreating and importing intil you are happy.

And of course you end up with a reasonable level of documentation on what you did.

If you do it this way youi can do existsnace checks, autonumber reseed, dependancy order etc, instead of relying on a wizard ton guess it's way through.

HtHs

This discussion is closed to new replies.