| By product |
| Other |
|
Troubleshooting Troubleshooting and known issues with ApexSQL Tools System.OutOfMemory exception is thrown Applies to ApexSQL Diff, ApexSQL Log, ApexSQL Doc Summary This article explains what to do when the System.OutOfMemory exception is thrown Symptoms System.OutOfMemory exception is thrown. It usually happens when working with large databases, backups or script folders containing large number of objects, generating huge scripts or putting application under strain in general. Cause The exception is caused by the .NET framework architecture and the way it allocates memory. Due to the nature of the .NET framework, this cannot be completely removed, however it can be worked around. Resolution Use Command Line Interface that these ApexSQL products contain. Using CLI puts less strain on the machine resources. You can either save your project using GUI and then execute it via CLI, or you can specify all the parameters using CLI entirely. To make your project using GUI and execute it via CLI: 1) Make your project using GUI and save it 2) Open Command Prompt 3) Navigate to the ApexSQL product installation path (e.g. cd C:\Program Files\ApexSQL\ApexSQLDiff\ or cd C:\Program Files\ApexSQL\ApexSQLLog\) 4) Type: a) for ApexSQL Diff ApexSQLDiff.com /project:<project path>\<project name> (e.g. ApexSQLDiff.com /project:C:\Users\ApexUser\Documents\ApexSQL\ApexSQLDiff \project.axds) The script file named “sync.sql” will be created in the ApexSQL Diff installation folder. b) for ApexSQL Log ApexSQLLog.com /project:<project path>\<project name> /undo:<filename> (e.g. ApexSQLLog.com /project:C:\Users\ApexUser\Documents\ApexSQL\ApexSQLDiff \project.axlp /undo:undoscript.sql) The script file named “undoscript.sql” will be created in the ApexSQL Log installation folder. Instead of using CLI in ApexSQL Log, you can output the results into a file and thus avoid showing them in the Main grid. 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 December 01, 2011 Labels: ApexSQL Diff, ApexSQL Doc, ApexSQL Log ...When I double click to open Compare It! it appears unregistered Applies to ApexSQL Diff Summary This article discusses use of Compare It! as an optional 3rd party add-in for ApexSQL Diff. We don't develop it ourselves or distribute free keys for it anymore. Resolution This product isn't necessary since all Compare it! functionality is included in ApexSQL Diff application itself (in the Difference viewer panel). We include it though since some customers like to have the power of a 3rd party tool - for line margining, printing etc. You can disable this option (via the ApexSQL Diff Application options dialog (Diff viewer tab | Show in context menu option)) or simply not double click - just click a row - to display line level differences. About ApexSQL Diff ApexSQL Diff is a comparison tool that compares and synchronizes SQL Server database tables, views and all other SQL Server objects. Compare SQLServer 2000, 2005, 2008 and 2012 database schemas, database backups, and integrate with all major source control systems. Use ApexSQL Diff to deploy a specific SQL database version or label directly to or from source control Last updated November 25, 2011 Labels: ApexSQL Diff ... |
