What are the minimum Windows permissions required to install and use ApexSQL Propagate?
Learn more about minimum Windows permissions required to install and use ApexSQL Propagate on this link
Can I execute a set of scripts on several databases at once?
Yes. Set the list of scripts in the Scripts pane and the list of databases in the Databases pane, and click the Execute button, from the Home tab
Can I create a list of scripts and reused it later on?
Yes. Click the New button in the List section under the Home tab, then choose the New script list option. If you want to reuse it, click the Open button, from the Lists section, and choose the Open script list option
Can I manage the order of scripts for the execution?
Yes. Each script can be ordered by moving it up and down, depending on desired execution order, using the Move up/down buttons from the Script section in the Home tab
Can I create a list of databases and reused it later on?
Yes. Click the Add database list button in the Databases section, under the Home tab and in the opened window you can add servers from which you can choose databases to create a list. When you want to reuse it, click the Open button, from the List section, and choose the Open database list option
Can I combine script lists?
Yes. Click the Combine script lists button from the List section, under the Home tab, load script lists on left and right side and move/copy scripts from side to side. Once the combining of scripts is finished, you can save the list as the currently loaded one or as a new list
Does ApexSQL Propagate supports Command Line Interface?
No. But, the next version of ApexSQL Propagate will have support for Command Line Interface along with some other features and you can read more about it from here
How is ApexSQL Propagate licensed?
ApexSQL Propagate is a free tool and you can use it with as many servers as you want
SQL Server support
What SQL Server editions are supported?
ApexSQL Propagete supports SQL Server Express, Standard, and Enterprise editions
Does ApexSQL Propagate supports Azure SQL Database or SQL Server on Amazon RDS?
Yes. ApexSQL Propagate supports Azure SQL Database V12 and SQL Server on Amazon RDS
Can I connect to different SQL Server editions when creating a database deployment list?
Yes. You can connect to any of SQL Server editions or Azure SQL Database server or SQL Server on Amazon RDS, and create a deployment list of databases by combining any of these servers
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
How can I check if the script will be executed successfully before the execution?
You can parse scripts prior to execution with a click on the Parse button from the Home tab
Will I get information if an error is encoutered while executing scripts?
Yes. If an error is encountered during the script execution, you can see the execution results in the Result pane, along with the error message
How can I manage errors during the script execution?
You can choose one of the following options for the Error handling in the Options window, from the Home tab:
- Contiunue execution
- Skip for databases where errors occur
- Stop for databases where errros occur
- Stop execution
How are the execution results shown?
You can view the exectuion results by scripts or by databases
Can I export my execution results to file?
Yes. You can export your execution results in CSV and TXT file