Migrating DB from Access 2000 to SQL Server 2000
Posted on 2002-06-21
I used the import wizard on an empty d/b from the sql server, setting as source the Access2000 file and destination my empty d/b. All went ok, but I didn't get the database diagram, and all the primary/foreign/etc keys have also been reset...
Is there a way to migrate/upscale without losing the er diagram and the primary keys?