hey Philip Horan,
Nope, I am trying to copy data from DB2 to DB1 and both the database is having data. more over to that in my DB1 and Db2 the structure are same.
and As I specified when i am copying the data. the Identity changes in Db1 for Db2 data for Example
===================
Database: DB1
----------------------
Table : Users
=========
UserID
------
1
2
-----------------------------
Table : Groups
=========
GroupID
------
1
2
----------------------------
Table: Group_Users
===============
UserID GroupID
------ -------
1 2
2 1
==========================================
Database: DB2
----------------------
Table : Users
=========
UserID
------
1
2
-----------------------------
Table : Groups
=========
GroupID
------
1
2
----------------------------
Table: Group_Users
===============
UserID GroupID
------ -------
1 2
2 1
============================
If I copy data user and Group Data from Db2 to Db1
then My result will be like this
=============================
Database: DB1
===============
Table : Users
=========
UserID
------
1
2
3
4
-----------------------------
Table : Groups
=========
GroupID
------
1
2
3
4
----------------------------
Table: Group_Users
===============
UserID GroupID
------ -------
1 2
2 1
===============
3 --
4 --
===============
My Issue is here, how can i keep track of which userid is belongs to which groupid because all the ID will be new in Db1
Can you please look into my Issue?
hey Piotr,
Can u look into above data?
Cheers!
Sandy.
--