ApexSQL Script
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, .NET executable and C# project
|
|
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
Source control systems support
|
|
Can I check in the script directly to a source control system?
|
|
|
Which source control systems are supported by ApexSQL Script?
|
Subversion and the following MSSCCI-compatible source control systems are tested and supported by ApexSQL Script:
Microsoft Visual SourceSafe
SourceGear Vault
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