Can I merge two tables together?

[pwel]

I have two sql databases on the same server, one is a copy of the other(the live db)!

I have been making ammendments to a table in the copied db and now wish to merge it back into the live db table.

I need to leave any new information in the live table intact, but replace the old information with the ammended information from the copy!!!!

Can I do this?

I have tried to DTS the table back into the live DB using the import data function, with no luck, it deletes the new information from the live copy?

Please help.

Paul Welding.

 

[TomSark]

Do you have an easy way of knowing which rows have changed so that you could simplify this into an update statement?

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[calahans]

CREATE TABLE TEMP AS SELECT * FROM ORG_TABLE

DROP ORIG_TABLE

CREATE ORG_TABLE AS (.....Use the table script for the new version).

INSERT INTO ORG_TABLE SELECT * FROM TEMP (IF THE NUMBER OF COLUMNS HAVE NOT CHANGED)

INSERT INTO ORG_TABLE (COL1,COL2..THE OLD COLS) SELECT * FROM TEMP

Even if you changed a datatype (well from number to char) it will work...



Cal