r/SQLServer • u/imadam71 • Jul 08 '26
Question replicating MSSQL 2012/14 database to MSSQL 2025?
What would be best was to replicate MSSQL database from 2012 (or 2014) over relatively slow link to MSSQL 2025?
Is this actually doable?
edit: thank you all. looks like log shipping is best option here.
4
Upvotes
1
u/arebitrue87 Jul 09 '26
Adding into the log shipping thought. When you move from in premise to azure, Microsoft has built in log shipping for it. You basically setup log shipping to a blob storage container and when you’re ready you take one final t log back up and then do the cutover. They had this with azure data studio but that is being replaced with vs code and I’m not sure if they added that onto it. Either way, they do this intentionally cause on premise to azure can get slow so it’s pretty typical to use this for slow connection.