SQL Server - Merging Two Tables with PK on both tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL Server - Merging Two Tables with PK on...

SQL Server - Merging Two Tables with PK on both tables

Rate Topic

Display Mode

Topic Options

Author

Message

dasarishiva

Posted Monday, October 22, 2012 2:01 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 11:34 AM
Points: 3, Visits: 47

Hello,

I had a situation where we have two different DBs with Table-A (on DB1) & Table-B (on DB2). I have to merge both tables to a single new table (Table-C on DB1 or DB2 or NewDB).

Here Table-A & Table-B are PK enabled & need the same on Table-C. Just want to know few suggestions/approaches on how to handle PK conflicts while in merging process.

Brief questions:
1) Approaches/suggestions to merge these tables.
2) Approaches/suggestions to handle PK conflict records during this merge process.

Kindly provide detailed explanation in doing this.

Post #1375713

Bhuvnesh

Posted Tuesday, October 23, 2012 5:50 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

your requirement is basically De-normalization approach. First remove duplicate coluimn some time you need to merge the coluimn (concatenation of data like name = first name + last name )

for Pk u need to see how data willl be uniquely defined means what are the columns good for PK candidate its not neccessary that old two table's coljumns will be used for PK.

and for detail , post ur table defintion BigGrin

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1375981

« Prev Topic | Next Topic »

Permissions