CODEWITHSUNDEEP
sql-serverdatabasewindowssynchronization
lucTiber
lucTiber

Reputation: 431

Database synchronisation in SQL Server

I have a question with regards to synchronizing 2 DB on a daily basis, but first let me share some context.

Technical environment:

Functional environment: the main database is a production database. It is populated every morning using informatica with a full export from a partner data base (FYI no way to modify the latest).

When my production is populated then I create a dump and populate another database for data sciences/BI/... to play with (first the BI DB is purged).

When BI database is populated, there is no synchronization required between production & BI during the day. Both database live completely unconnected during the day.

In the current situation, the BI team is able to connect at its database by mid day (due to the volumes ~ 500 G every day) - this is not acceptable

So now we have some context, how could I make sure the BI database is ready for use as soon as the production database is populated.

Any idea is most welcome so feel free

Upvotes: 0

Views: 49

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89371

Your options AFAIK

1) Dual-Load both databases from the ETL tool.

2) Use a disk snapshot or a VM snapshot.

3) Put the production database in Full recovery mode and use Log Shipping

Upvotes: 1

Related Questions