Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-22 : 10:25:53
|
| lil writes "I currently need to import a number of tables from MS Access to SQL 7.0 using DTS. When this happens I have to either alter the script in DTS to set the IDENTITY property of the field for each table or, when the tables have been imported I have to enter the design of the table and specify the IDENTITY field. It is also necessary for me to manually enter any default values. This is proving to be a very time consuming task - is there any way of automating this?" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-05-22 : 11:51:22
|
I disagree with your assertion below. You can, through appropriate data mappings, define a DTS transformation which honors both the identity column and any defaults on the destination table.Describe what you're doing w/ DTS in more detail; there definitely is a way to completely automate the transform.quote:
When this happens I have to either alter the script in DTS to set the IDENTITY property of the field for each table or, when the tables have been imported I have to enter the design of the table and specify the IDENTITY field. It is also necessary for me to manually enter any default values.
setBasedIsTheTruepath<O> |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-05-22 : 19:08:23
|
| Or you could always use the Access Add-in to up-size to SQL Server. It does a nice job of retaining IDENTITY fields as well as foreign key relationships. |
|
|
|
|
|
|
IDENTITY Property, Default Values and DTS