Page 1 of 1

Commandline snapshot creation fails

Posted: Mon 17 Nov 2014 13:34
by 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 />

Re: Commandline snapshot creation fails

Posted: Mon 17 Nov 2014 14:40
by 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

Re: Commandline snapshot creation fails

Posted: Wed 19 Nov 2014 11:03
by mish666uk
What is the correct syntax for generating a snapshot of a database from the command line?

Re: Commandline snapshot creation fails

Posted: Wed 19 Nov 2014 11:25
by 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"

Re: Commandline snapshot creation fails

Posted: Wed 19 Nov 2014 14:43
by alexa
We will fix this issue in the next product build and will notify you once it's available for downloading.