| By product |
| Other |
|
Knowledgebase Tips and how-to articles for ApexSQL tools What ApexSQL Diff API files should I distribute along with the application? Applies to ApexSQL Diff API Summary This article lists the ApexSQL Diff API files that should be distributed with the application to ensure ApexSQL Diff API functionality Description The files that need to be distributed are: ActivationBroker.exe ApexSql.Backup.dll ApexSql.Common.Activation.dll ApexSql.Common.BackupMetadata.dll ApexSql.Common.CommonLib.dll ApexSql.Common.Decry.dll ApexSql.Common.Dependency.dll ApexSql.Common.ExceptionReporter.dll ApexSql.Common.GrammarParser.dll ApexSql.Common.OfflineMetadata.dll ApexSql.Common.Scripting.dll ApexSql.Common.ScriptMetadata.dll ApexSql.Common.SourceControl.dll ApexSql.Common.ZipLib.dll ApexSql.DataDiff.dll ApexSql.Diff.Api.dll ApexSql.Diff.Api.xml ApexSql.Diff.dll ApexSql.Engine.dll ApexSql.SourceControl.dll ApexSql.SourceControl.Interfaces.dll ApexSql.SourceControl.SourceSafe.dll ApexSql.SourceControl.Subversion.dll ApexSql.SourceControl.TFS.dll ApexSql.SourceControl.Vault.dll ApexSqlBackupCore.dll ApexSqlDiffApi2011Activation.dll DynLib.dll The AddIns sub-folder from the ApexSQL Diff API installation folder also needs to be distributed Place the files (and the AddIns sub-folder) into the same folder where the application executable is located About ApexSQL Diff API ApexSQL Diff API programmatically compares and synchronizes SQL Server database tables, views and all other SQL Server objects as well as database data. Compare databases programmatically from your custom application Last updated April 7, 2013 Labels: ApexSQL Diff API ...How to execute large SQL scripts Applies to ApexSQL Data Diff, ApexSQL Diff, ApexSQL Log, ApexSQL Recover Summary This article shows how to execute large scripts created by ApexSQL tools which are too big to be opened or executed by SQL Server Management Studio Query Editor Description Synchronization scripts, undo and redo scripts, and recovery scripts generated by ApexSQL tools can be so big that SQL Server Management Studio Query Editor can't open and execute them To run these scripts use: 1) The osql Command line utility that comes with SQL Server: osql -H <computer_name> -S <instance_name> -U <username> -P <password> -i <path> 2) The sqlcmd command line utility that comes with SQL Server: sqlcmd -S <computer_name\instance_name> -d <database_name> -i <path> -o <output>3) ApexSQL Script Utility: a) Download ApexSQL Script Utility. Send an email to support@apexsql.com to get the link b) Unzip it into a folder c) Use the Command line and navigate to the folder where the file was unzipped d) Run the utility with the following parameters: ApexSqlRunScript <computer_name\instance_name> <database> <path>About ApexSQL Log ApexSQL Log is a SQL Server Transaction Log reader that allows viewing transaction log data in read-friendly format. Audit and undo SQL database changes of your choosing. Determine who changed the data and when the change occurred. Read the transaction log to find out who created, changed or dropped a database object Last updated April 7, 2013 Labels: ApexSQL Data Diff, ApexSQL Diff, ApexSQL Diff API, ApexSQL Log, ApexSQL Recover, General ... |
