Can I backup the server DB and restore it as client DB #691
Unanswered
ReinholdGuenter
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hello,
I want to synchronize a pretty large database from a legacy project.
Both server and client databases are using SQL Express.
The initial synchronization process takes a lot of time and sometimes produces command timeouts.
I have already tried utilizing the snapshot functionality, but even then the process takes several hours.
Is it possible to back up the server database, restore it on a client and finally mark it as already synchronized client database?
The backup and restoration would be done manually with SQL Server Management Studio.
Would that be possible by deprovisioning and provisioning the client DB with the right SyncProvision enum parameters or so?
Beta Was this translation helpful? Give feedback.
All reactions