I have 3nos. of table in my database (DB1) like Users, Groups and Goup_Users
In Users table, UserID is Identity
In groups table, GroupID is Identity.
In Group_Users table, UserId and GroupID columns are presents.
Now I have another database (DB2) having the same structure.
I have to copy the Users, Groups, and Group_Users from the DB2 to DB1.
Here my problem is the Identity column in both database, I can remove the Identity and copy the data. But for DB2 Group_Users combination should be same after transfer to DB1.
Can you please give me the idea how can I achieve it?