1

Many similar questions were asked before, and mostly about comparing database schemas and data. That's all fine, but what about all the other SQL Server objects in the system overall?

This is the closest answer I've found, but it doesn't answer my query on a tool to be able to also create an SQL script of the variances, that can be easily applied to another server - including new user logins, roles, schemas, linked-servers, maps, maintenance plans, etc.

The other tool I found that does this is TOAD for SQL Server, but it's not cheap. I was hoping for an SQL script solution? Particularly with a mix of SQL Server environments from 2008 R2 to 2017?

Thanks

2
  • 1
    There are some 3rd party tools like ApexSQL Diff and DataDiff or RedGate SQL compare that could help.
    – McNets
    Jan 7 '20 at 15:02
  • 1
    Have you taken a look at dbatools? It is a free, community-maintained PowerShell module that provides an extensive range of migration-based cmdlets to migrate whole instances from one instance/server to another (among many other things the module can do).
    – HandyD
    Jan 8 '20 at 0:04
1

Thanks to @HandyD, dbaTools does this and more! Cheers

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.