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 |
|
chandran.nr
Starting Member
4 Posts |
 Posted - 2013-06-07 : 06:40:58
|
| HiI am having local server and remote server.In the local server ,i have database table which is inserted,updated regularly.There is no primary key in the table .Once in a week i want to copy the differential data to be updated in table of remote server.Both table structures are same.Please help me to find the solution.Thanks Chandran. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2013-06-07 : 06:43:14
|
| Is there a way of uniquely identifying each record, so that you know which are new and which aren't?Do the records have a timestamp so that we know when they were created?If the table is not too big you can just do a full reload.Duane. |
 |
|
|
chandran.nr
Starting Member
4 Posts |
Posted - 2013-06-07 : 06:48:49
|
| There is no unique id or primary key.timestamp is fine,but it is difficult to find out which row should be updated and which one is to inserted newly using timestampThankschandran. |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2013-06-07 : 06:50:41
|
| Then I would suggest adding a Primary key.Duane. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-07 : 06:57:32
|
quote:
Originally posted by chandran.nr
There is no unique id or primary key.timestamp is fine,but it is difficult to find out which row should be updated and which one is to inserted newly using timestampThankschandran.
Is there atleast set of columns using which you can determine a row unqiuely?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
How to copy data from local to remote server