What data sources can I use to create a deployment script?
The following data sources are supported: T-SQL script files, script folders, ApexSQL snapshot files and versioned scripts
What types of build packages can be created?
The following package types can be created: T-SQL deployment scripts, C# projects (.sln files) and .net executables (.exe files)
Can build packages and scripts be used for creating new databases as well as updating the existing ones?
Yes, just select the Create a new database or Update an existing database option
What database properties can be user defined for newly created databases?
The following database properties can be customized: the path where a physical database (.mdf file) and transaction log files (.ldf files) are stored, collation, recovery model, compatibility mode and database size. Additionally, the Get database properties from input source button can retrieve and use properties defined in the input
I don’t want to create all database objects. Can I remove the ones that are no longer needed from a script?
Yes. You can select only the ones you want to create from the list of all objects
If I don’t script all objects, will I be warned about the dependencies that are not selected for scripting?
Yes. Even if you don’t select the child and parent objects for an object, they will be added. A list of dependent objects and references is shown in the preview step of the wizard
I have a script that I want to execute after a database is created/ updated. Is there an easy way to do this?
Yes. Add that script to the Add optional scripts step of the wizard. This script will be executed, but not added to the created script, C# project or .Net executable
Can I have several scripts combined into one?
Yes. Use the Consolidate scripts into a single script option
Can I specify the order of scripts in a consolidated script?
Yes. The order shown in the Order column will be used in a consolidated script. You can easily move the scripts up and down
Will I be warned if something goes wrong while executing the created .Net exe file?
Yes, if you want to. You can define the way for handling errors – abort the execution, ignore errors or ask for confirmation
Can I execute a set of scripts on several databases at once?
Yes. Use the Execute scripts on multiple databases option
I have multiple SQL Servers that I want to execute scripts against. Can I save these SQL Server instances?
Yes. You can save the SQL Server instances, against which scripts will be executed, as Server lists