CODEWITHSUNDEEP
sqlsql-serverdatabasedatabase-administration
shahram_javadi
shahram_javadi

Reputation: 289

Best way to syncing two different database

I have two database(SQL Server) one database has 2.5 million records and the other one is empty, i want to transfer data from first one to the second one and after that every time first database has been changed the second database must sync. And we must do it in offline way with excel file for example(there is no online way between them) , Can anyone show me a guideline to do this?

Upvotes: 0

Views: 686

Answers (2)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

There is only one out-of-the-box solution for offline replication, ie that doesn't require a network connection from the the distributor to the publisher and from the subscriber to the distributor or distributor to subscriber.

Snapshot Replication with Alternate Snapshot Location. You take a snapshot of the published tables, copy the snapshot somehow to a location visible to the subscriber, and then apply the snapshot from the new location.

Upvotes: 1

Amin Pashna
Amin Pashna

Reputation: 161

There are different ways to do that but I think the easiest could be replication, you can use Transactional replication or snapshot replication.

https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-replication?view=sql-server-ver15

Upvotes: 0

Related Questions