Use Case 1: SQL Partial Backup in Script mode:
If there were a requirement of keeping a backup of SQL server object like Stored Procedure, Functions, Views, Users, permissions, or selected Table’s schema (May be with data) for any reason example to reduce space or time etc.
Use Case 2: SSMS Wizard scripting Mode Automation Limitation:
If there is a requirement of generating specific table or objects script as part of backup and automate, SQL Server management doesn’t support it but it can do once on demand only. To overcome it, SQL Planner has covered automation part by scheduling it.
Use Case 3: Degrade SQL Server requirement:
For any reasons if you wanted to degrade SQL server version from higher version to Lower version, you can generate scripts using SQL Planner scripting tool and once script generated , it can manually be executed in lower version easily.
This can be done with ease using SQL Planner tool Scripting Job, define your server and database, once connected choose specific or all objects and behavior and save as job.
Once saved go to Dashboard and view maintenance job , and click on action then Execute or schedule as per your need.
Once Executed the scripts are saved in Zip format at this path C:\SQLMaintenancePlanner\DBScripts on SQL Planner Host machine.
To download visit here