Rajesh Bhat
Reputation: 811
Generation of schema scripts for all the objects across all databases
Before DB deployment, we need to take backup of all the schema scripts (Tables with index & triggers, SPs, functions, table data types). We have more than 5 databases. Is there any automated way of taking scripts from all these objects across all the databases with different script file for every database?
Upvotes: 0
Views: 29
Answers (1)
MJ Miller
Reputation: 23
Related to https://dba.stackexchange.com/a/56625? You don't specify how often and how many databases to script, but you did say 'automated'. The Powershell tooling for SQL Server is probably your best bet.
Upvotes: 2
Related Questions
- Script out all SQL objects under particular schema
- How to script out all databases objects for all databases at the instance level
- Programmatically generate script for all objects in a database
- SQL Server 2008 - create database script (schema + data) with command-line
- Generating DDL/DML scripts for all tables/columns in a database
- Generate script for both schema and data
- Generate script for all objects for SQL Server Database
- Generating script for database schema changes
- How do I reconstruct a database schema from hundreds of separate scripts?
- SQL Server: Script all DB objects (SP, Tables, Triggers, etc.) to SQL script