Import Export Wizard - Need the package to include primary key definitions on created tables
I'm basically duplicating an Access database in SQL Server 2008. The upsize wizard in Access is useless - spews dozens to hundreds of errors on every conceivable subject, mostly incorrectly, so went to SSIS. The package generates just fine as far as basic table def and data moving is concerned, but the resulting tables (and there are a few hundred) have no primary keys, nor index, nor RI definitions. This is a pretty poor way to move data, especially when SSIS knows it is creating the tables. Is there some way to get these definitions (at least PK) included in the database, or must I manually reproduce some thousand or more PK, FK and RI definitions - thus rendering any gain more than a little moot?
November 13th, 2009 1:28pm

Can you export FK definitions from Access to a file and edit it for SQL Server?Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com
Free Windows Admin Tool Kit Click here and download it now
November 13th, 2009 2:23pm

Access has no scripting capabilities whatsoever (to generate DDL from its database). There is no way to get a DDL-like definition of tables, FK, etc.
November 13th, 2009 8:31pm

Yeah, This is the typical response I am finding digging through these forums for a reason why I do not get my PK, FK and general constraints imported from Oracle!!!
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2011 5:41am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics