Pl sql updating tables from another table parent advice on dating
It's a full-blown Extract-Transform-Load (ETL) tool specifically built to manage and automate this kind of work.
You can also use bulk insert mechanisms within T-SQL, bcp, BULK INSERT and OPENROWSET all support the ability to export data from one database and import it into another.
works fine when I try to update all the records in tbl A, however, in this case I only have missing data which I have identified and populated in tbl B.
Consequently, to prevent this, you might do this: One potential issue may arise when the subquery actually finds more than one matching row in tbl B.
If this happens, the UPDATE will terminate with an error ("subquery may return only one row").
Last, there are tons of 3rd party tools that support this.
Take a look at Redgate Software's SQL Compare and SQL Data Compare.
The first table, violation_codes, has a section_number and fine, among other columns, but these two are the focus of the problem.