Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-28 : 08:41:41
|
| Keith writes "Hello - I have two databases. One named OLD, the other named NEW. They have different table structures, but share much of the same data. OLD has a table named PROFILE, which contains three columns, DOCNUMBER, DOCNAME & CLIENT. NEW has a table named DOCMASTER, which has three columns as well, DOCNUM, DOCNAME & C1ALIAS. DOCNUMBER AND DOCNUM contain the exact same data. Both DOCNAME columns from both databases contain the exact same data as well. The only difference is that the CLIENT column in the OLD databases is populated with entries where the C1ALIAS column in the NEW database is not populated. Here is what I would like to accomplish...I would like to some how copy the data from the CLIENT column in PROFILE table of the OLD database to the C1ALIAS column in the DOCMASTER table of the NEW database, while keeping the rows matched up identically.I would like the similar columns to look exactly the same in the NEW database. Would this be easier done by running query or by importing the data from one database to another? Any help would be greatly appreciated! I hope my question made some sense.Thank you!Keith" |
|
|
|
|
|
Moving Data