Microsoft tried: in the Microsoft .NET Framework era, things in the database tooling department grew, but also meandered a bit: The simple script-container database projects were brought forward into ...

I've been playing with the new SQL Server Data Tools, and I'm impressed by the way Microsoft has gotten the product out for review and is improving it with user-requested functionality.

I've been playing with the new SQL Server Data Tools, and I'm impressed by the way Microsoft has gotten the product out for review and is improving it with user-requested functionality.

You can treat SQL Server on Linux as a new deployment option, not a whole new database. That means you can choose the operating system that best fits your project.

Using the Copy-DBAAgentServer command, you can bring over everything in the SQL Server Agent, including jobs, notifications, operators and alerts. Log-ins work in the same easy manner.

I've been using the Schema and Data Compare tools built into Visual Studio. They seem to work pretty nicely and will generate change scripts. Might be worth a look if you've already got Visual Studio.