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 |
|
padamgondenk2001
Starting Member
4 Posts |
 Posted - 2008-08-04 : 03:35:01
|
| Hi Everybody,I am playing with SQLserver 2005, last 3 years, but i have one query that is as follows.I am tring to update my old database with New database which has containg some new record in table t1, t2, t3 and T4.i tried to upend update using import data from new database table with assign the old database. in this case i would like to update only New Entry Records should be update but it update hole recores.Can any budybudy Help me.Padamgonde N. KSoftware Developer,HOL Infosolution Pvt. Ltd.Pune, India |
|
|
pkuchaliya
Starting Member
49 Posts |
Posted - 2008-08-04 : 04:29:02
|
| Create a join between these two database. then it will update only exact match record.pankaj |
 |
|
|
padamgondenk2001
Starting Member
4 Posts |
Posted - 2008-08-05 : 05:10:02
|
quote:
Originally posted by pkuchaliya
Create a join between these two database. then it will update only exact match record.pankaj
Thnks for solution but how it posible to join the two database in one same serverPadamgonde N. KSoftware Developer,HOL Infosolution Pvt. Ltd.Pune, India |
|
|
|
|
|
|
Updating Database with new records........