SQLScripter is a powerful command line utility designed to automate the process of schema generation.
SQLScripter simply preserves your schema on the file system at many points in time allowing you to easily access any object that you may need, be it a Stored Procedure, a Job, a Login, Partition Function or any other object instantly.
The utility supports various switches providing flexibility to meet any environment’s requirements.
For example you can select which server(s) to script, which database(s) on each server, which object types to script etc. and you can also select if each object type goes into a single script file or each object to its own dedicated script file.
SQLScripter can script an unlimited number of servers from a single location resulting in a central location having the entire environment’s schema handy for any need.
All that is needed is a one time configuration, schedule and that’s it.
The utility supports all Windows Operating Systems and all SQL Server versions 2005 to 2019.
Top level root folder – servers
1 level down – databases
2 levels down – objects type
3 levels down – objects (stored procedures in this example)
Logins script (including the password hashed for sql logins)
Jobs
A job script example
Latest posts by Yaniv Etrogi (see all)
- Monitor AlwaysOn Availabilty Groups - July 6, 2023
- SQL Server – The secret index syntax - February 8, 2023
- Use .net SqlClient with Powershell to access data - January 25, 2023
- Use Powershell to find unused resources in Azure - August 5, 2022