Find tools to help you easily build, debug, maintain and refactor databases inside Visual Studio in the eBook: DevOps for Databases. And, learn how to:
- Generate database scripts with mssql-scripter. Get CREATE and INSERT T-SQL scripts for database objects in SQL Server 2017, SQL Database and SQL Data Warehouse from the command line.
- Enter Transact-SQL statements, system procedures and script files at the command prompt with sqlcmd.
- Use SQL Server Data Tools and Visual Studio Team Services for an intuitive experience when updating your database for new app versions.
- Use Redgate Readyroll, offered through Visual Studio Enterprise, to make ALTER and CREATE statements for the various changes the app predicts.