I have 2 databases, a live and backup. I want to overwrite the the values in a specific field in the live database from those that are in the backup. The database structure is identical the only difference is there name.
How do I do this?
Asked
Active
Viewed 67 times
-1
-
Do you have a column that identifies the *rows* where the columns should be matched? – Gordon Linoff Nov 26 '14 at 12:09
-
The databases are called Live & Backup1, the tables are both called order_line_analysis, the columns to update are called ola_m_1 – TowelsRus Nov 26 '14 at 13:15
-
. . That wasn't my question. What identifes the matching rows between the rows in the two tables in the two databases? – Gordon Linoff Nov 26 '14 at 16:35
1 Answers
0
Try this
UPDATE liveDB
SET column2 = src.column2 -----Whichever column you want
FROM BackupDB.dbo.Table1 AS src
INNER JOIN LiveDB.dbo.Table1 AS dest
ON src.column1 = dest.column1;
Updated
UPDATE live
SET l.ola_m_1= b.ola_m_1
FROM live.dbo.order_line l
JOIN backup.dbo.order_line b
ON --Whatever is Similar column between two
Richa
- 3,261
- 2
- 27
- 51
-
ok still struggling a bit here. the live database is called live, backups called backup. the table is called order_line_analysis in both databases and the filed is called ola_m_1 I barely know SQL so any extra help would be greatly appreciated. – TowelsRus Nov 26 '14 at 11:32
-
Hi I just can't get it to work..The databases are called dstgood & dstbad, the tables are both called order_line_analysis, the columns to update are called ola_m_1. dstbad needs updating with data from dstgood – TowelsRus Nov 26 '14 at 14:05