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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2009-05-27 : 07:52:45
|
| I have 2 databases on different servers that I need to synchronize with each other - is there anyway of doing this?I have synchronized 2 networked databases but these are not networked. |
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-02 : 00:38:32
|
| HiTry SQLDelta, It is a very good tool, I use it in my office.http://www.sqldelta.com/1. Alternatively you have to keep track of all the changes that are done and then re run it on the live server.2. For the Data synchronization of new records you can use the import and export facility in SQL Server to transfer the data.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-06-02 : 01:08:37
|
| http://www.sqldelta.com/will this work even if the servers are not networked? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-02 : 10:41:40
|
| Once again. If there is no network connectivity between these two boxes, there is no way for them to synchronize.Which leads us to the question (again): What do you mean they are not networked?http://www.dbforums.com/microsoft-sql-server/1643070-synchronizing-2-mssql-databases.html |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-06-02 : 10:52:11
|
| they are not networked.the database is in the office server. Miles away is the server that the websites are on and I want a copy of the database on synchronizing to the office server. I have usernames and password for both but there is no network connection.there are at least 50 tables - i'm now writing procedures to move from one to the other records that are changed but this is a very time consuming and I really wonder if there is an easier way. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-02 : 11:05:45
|
| When you say there is no network between them, that implies that there is no way that these servers can ever talk to one another. There are no network cables that connect the two. Not just different subnets, not just different domains. What confuses me is that you are writing procedures to do this. How? If they are truly not networked, then there is no way a single machine (where these procedures are run) can connect to both machines. What are these procedures you are writing? Are the VB script? Stored procedures? Magic incantations?? |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-06-02 : 11:11:40
|
| i'm doing vbscript now They can connect by adsl but the connection is dependent on adsl which has proven as not reliable so I need the data replicated on both. |
|
|
|
|
|
|
synchronization between databases in different net