The easiest way to extract data

#1

Hello -

I like to merge two databases (contains the exact same structure) data
together. What is the easiest/best way to do that?

Most tables in both databases have sequential increment numbers as PK
ID numbers; therefore I need to skip extracting the PK ID and just
reinsert/repopulate it.

Thanks in advance.

#2

xo (xo5555ox (AT) gmail (DOT) com) writes:

Quote:

Most tables in both databases have sequential increment numbers as PK
ID numbers; therefore I need to skip extracting the PK ID and just
reinsert/repopulate it.

Are these incremental IDs also used as foreign keys in other tables?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

The easiest way to extract data

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

The easiest way to extract data - 08-23-2010 , 08:37 PM

Re: The easiest way to extract data - 08-24-2010 , 02:08 AM