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 |
|
rainmanjam
Starting Member
1 Post |
 Posted - 2011-02-21 : 12:48:35
|
 Hopefully I can explain this correctly.I am currently using MSSQL 2008 and I have two databases with 2 tables. In DB1, Table 1 has a username and a UserID. Table 2 has a GUID and a UserID. The UserID in table 2 is added to show which user added the row. I have migrated tables 1 and 2 from DB1 to DB2 but the UserID from Table 1 in DB2 is different from DB1. I want to keep the UserID and match up the users from DB1 into DB2 correctly to match up with table 2 in DB2. The UserID in Table 2 in DB2 should change. Is there an easy way of doing this? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-02-22 : 01:32:24
|
The question is why the UserId has changed.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Syncing table between two different databases