The DTS import/Export Wizard does not automatically generate indexes or constraints for Access tables. The Access Upsizng wizard, however, will create indexes and constraints. The approach I used recently was to use the Access Upsizing wizard to upload the structure only. I then created generated a script and edited it (ie change nvarchars to varchars etc) and then I used the DTS Wizard to import the data. This seemed to be the approach that was generally recommended on the web.
"Ldraw" wrote:
Quote:
I created a .bas from the export utility in SQL 2000 based on a Access
database that I wanted to import into SQL Server. After running the Vb application created with the .bas file the table definitions and the data are there but there are no constraint definitions or indexes.
|
RE: .bas for VB no indexs or contraints -
07-21-2004
, 03:39 PM
Linear Mode
