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 |
|
s2002
Starting Member
49 Posts |
 Posted - 2010-10-25 : 14:50:43
|
| HelloHow is it possible to synchronizing 2 DB on different server without using replication?I only want to insert new records from one DB to another.Regards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
s2002
Starting Member
49 Posts |
Posted - 2010-10-25 : 16:24:52
|
| Cause replication is not installed on server and I don't have System admin privilages.I need this to be done once. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-25 : 21:30:25
|
| are you dbo on the database in question? else, you can't do it. sounds like you need to discuss the need and the solution with those who do have the permissions to implement this.if it is a one time deal, have your sysadmin synch it for u |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-26 : 02:17:03
|
| We move a lot of data around using Linked Servers.We have an Update Date column on every table, which may help, as we use that to only include things changed since last time.EitherINSERT INTO dbo.MyTable(Col1, Col2, ...)SELECT Col1, Col2, ...FROM MyRemoteServer.MyRemoteDatabase.dbo.MyRemoteTableWHERE MyUpdateDate > @LastTransferDateorINSERT INTO dbo.MyTable(Col1, Col2, ...)SELECT * FROM OPENQUERY(MyRemoteServer, 'SELECT Col1, Col2, ...FROM MyRemoteDatabase.dbo.MyRemoteTableWHERE ...') |
|
|
|
s2002
Starting Member
49 Posts |
Posted - 2010-10-26 : 03:03:35
|
| Thank you Kristen. It works |
|
|
|
|
|
|
|
|
synchronizing DataBases