General
Can ApexSQL Script script multiple databases at once?
Yes. Select all the databases you want to script
What output types are supported by ApexSQL Script?
The supported output types are T-SQL, C# solution, and Executable installer
Can I create structure and data script at the same time?
Can I open the scripts in some other editors?
Yes. You can set ApexSQL Script to open the created scripts in Query Analyzer, SQL Server Management Studio or some other editors
Can I script logins and permissions?
Source control systems support
Does ApexSQL Script supports source control systems?
Yes. Source Control system support is available in ApexSQL Script Professional
Which source control systems are supported in ApexSQL Script Professional?
Git
Mercurial
Perforce
Subversion
Team Foundation Server
.NET packages
Do the generated .NET packages allow command line mode? If so, where can I find the switch set?
Yes. To see the available options, start the executable in command line mode with either the /? or the /help switches
What will my end users need to run the generated packages?
To run the packages, the .NET environment version 2.0 or higher must be installed
Structure mode
Does ApexSQL Script script encrypted objects?
Yes. To script encrypted objects you must have membership in the sysadmin server role
Can ApexSQL Script automatically generate an object existence check?
Data mode
Is it possible to define other names for objects being scripted in the Data mode?
Yes. You can set an alias for each object that you want to script
What does the Max column in Data mode do?
Max column determines the maximum number of the rows that will be scripted for a particular table
What if my script has an error? Will this cause any damage to my database?
Include transaction handling to enclose the scripted statements within a transaction. The transaction will be rolled in case of an error
Does ApexSQL Script manage referential integrity problems related to triggers and constraints?
Yes. Make sure that the Disable all triggers and constraints prior to loading data option is ON