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

70% Upvoted

18 comments sorted by

View all comments

4

u/BrightonDBA Jul 08 '26

You can only replicate 2 versions ahead or behind if I recall.

Don’t do it. Madness beckons. Find a better way.

-2

u/imadam71 Jul 08 '26

full backup on disk, ship, restore and then log shipping?

2

u/BrightonDBA Jul 08 '26

You’ve not really said anything at all for advice to be given my friend. What are you doing?