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 |
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
 Posted - 2009-07-21 : 22:22:59
|
| hiI have an access table(tblA) with auto number as primary key and that it join to tblB as a FKI need to migrate to MSSQL. How do i convert those numbers to unique identifier in both tblA and tblB and also make sure that both tables unique identifier relates correctly? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-21 : 22:34:59
|
| don't use uniqueidentifier. use int (or bigint) and make it an identity column. make sure to set identity_insert on when inserting the values (this is a checkbox if using SSIS/DTS) |
 |
|
|
|
|
|
Data Migration