Replicate two disconected computers? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replicate two disconected computers?

Hello,
is it possible to replecate two coputers which are not connected, for instance: they do not have internet connections and they are not connected through cable?. I mean to transfer data with CDs( copy data from one computer to another) manualy and then to execute syncronisation.
Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases for consistency and connection must be available in order perform those set of activities. In your case you can deploy BACKUP/RESTORE method by copying backup file to the media and restore on the other server. REfer to books online for BACKUP & RESTORE topics. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
yes, but let’s say that bothe databases change data, in this case if you do backup on one side and restore in another side, it will overwrite changes made from destination Database, I mean to syncronise changes of bothe databases.
In this case when changes are being made in both database , u must go for merge replication.
and if setup of replication is not possible then in this case u restore the data with a different name and do the BATCH Processing. Sandy (DB Developer)
True, if the both database needs a synchronisation with different data then you require replication topology. Otherwise this BACKUP/RESTORE would work to keep the other database as a standby. For this type of replication refer to the books online for ‘Online/Offline Applications ‘ topic. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Replicating machines that has no network connections is possible, using backup and restore processes. But ensure the restoration point for each machines has no activity on current databases. xpthinker
]]>