Commandline snapshot creation fails

[1234]

I can successfully create a snapshot of our database from the GUI. However, when I try to do the same from the commandline, I get the following output:

Code: Select all

=== Snapshot creation started ===

Command line: /snapshot /connection:"Data Source=localhost;Integrated Security=True" /database:"DATABASE" /file:"E:\db_schema\DB.snap"


Describing objects...70%

Error: Object reference not set to an instance of an object.

=== Snapshot creation finished ===

The resulting snapshot file contains basically just a self-closing "snapshot" tag:

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<!-- Devart (www.devart.com), snapshot file -->
<!-- Modifying this generated file will probably render it invalid -->
<Snapshot />

[alexa]

Could you please navigate to the installation folder of dbForge (by default, %programfiles%\Devart\dbForge Studio for SQL Server) and send us the text file with the detailed error report?

Also, please provide us the following information:

1. Version of dbForge Studio for SQL Server.
2. Version of SQL Server.

You can send a reply straight to our support system at supportATdevartDOTcom

[mish666uk]

What is the correct syntax for generating a snapshot of a database from the command line?

[mish666uk]

I think I am suffering from the same problem using dbForge Schema Compare for SQL Server Professional Edition 4.0.27. I am not getting an error file in my installation directory. Command line I'm using is:

schemacompare /snapshot /connection:"Server=???;User ID=???;" /database:??? /password:??? /file:"C:\temp\snapshot.snap"

[alexa]

We will fix this issue in the next product build and will notify you once it's available for downloading.