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

By coolbiker ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Depends on what version 2005 you have

by Tony Hopkinson In reply to Any way to import to sql ...

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.


Related Discussions

Related Forums