A collection of articles covering SQL script with schema and data scripting topics.
Exporting and importing data
Script automation
- Automatically script SQL Server table data and object schema directly to source control
- How to automate batch SQL object scripting and committing to source control
Scripting objects
- How to combine objects and data from multiple SQL databases in a single SQL script
- How to create DDL and DML SQL scripts for specific SQL database objects only
- How to script encrypted SQL database objects
- Script a database for specific DML records only
- Recommended methods for SQL database scripting
- How to script SQL Server logins and permissions
Scripting users
- How to script SQL Server database users with roles
- Transfer SQL logins for users with a large number of SQL-authenticated logins
Source control
- How to commit SQL Server table static data to a source control repository
- How to export a SQL database directly to source control
- How to work with SQL database source control labels
- Three phased approaches to getting your SQL Server database into source control
SQL productivity tools
