Activity overview
Latest activity by ax4413
I decided to try and accomplish my original goal by using the UI and it does exactly what I want. But when calling it from the command line I get the same error as before Object reference not set to an instance of an object. SQLDataCompare.exe /Project:'C:\temp\SourceTarget.sdc' /verbose
What gives??? / comments
I decided to try and accomplish my original goal by using the UI and it does exactly what I want. But when calling it from the command line I get the same error as before Object reference not set t...
Comparing Revision1 with Revision2 to compare static data
Hi,
Can any one help me. I am trying to compare the data of two revisions of my source controlled database. The background to this; is that I am trying to compare static data in a particular way. ...
I have resolved the issue my self. I use the following command.
sqlcompare.exe
/include="Identical"
/include="StaticData"
/sourcecontrol1
/revision1:HEAD
/scriptsfolderxml:"C:\ScriptFolderLocation.xml"
/migrationfolderxml:"C:\MigrationFolderLocation.xml"
/server2="localhost"
/database2="Target"
/scriptFile:"C:\SVN\Output\Diff.sql"
/verbose
Where scriptsfolderxml points to an xml file path which defines the script folder. see below:
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ISOCCompareLocation version="1" type="SvnLocation">
<RepositoryUrl>file:///C:/SVN/SVNRepository/trunk/Databases/Test1/Database/</RepositoryUrl>
</ISOCCompareLocation>
Where migrationfolderxml points to an xml file path which defines the script folder. see below:
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<ISOCCompareLocation version="1" type="SvnLocation">
<RepositoryUrl>file:///C:/SVN/SVNRepository/trunk/Databases/Test1/DatabaseMigration/</RepositoryUrl>
</ISOCCompareLocation>
These files were generated by myself, they do not exist as part of source control.
Hope this helps someone else. / comments
I have resolved the issue my self. I use the following command.
sqlcompare.exe
/include="Identical"
/include="StaticData"
/sourcecontrol1
/revision1:HEAD
/scriptsfolderxml:"C:\ScriptFolderLocation....
Thank you David Atkinson,
I had previously been trying to use the /MakeScripts switch which was wrong, all i need to do was use the /ScriptFile switch.
Can I ask one other question?
This is a question to do with migration scripts. I am using the below command, but this does not seem to be picking up the migration scripts that I have generated.
sqlcompare.exe
/include="Identical"
/include="StaticData"
/scripts1="C:\SVN\Code\trunk\Databases\Test1\Database"
/migrationsfolder:"C:\SVN\Code\trunk\Databases\Test1\DatabaseMigration"
/scriptsfolderxml:"C:\SVN\RedgateBuild"
/db2:Target
/scriptFile:"C:\SVN\Output\DiffScript.sql"
Scripts1 is the location of my database source control
MigrationsFolder is the location of the migrations folder associated with source control
ScriptsFolderXML is a folder I created which contains a xml file I generated following your advice in post http://www.red-gate.com/MessageBoard/viewtopic.php?t=14941
Can you offer any advice?
I can create a new post if that helps.
Thanks in advance / comments
Thank you David Atkinson,
I had previously been trying to use the /MakeScripts switch which was wrong, all i need to do was use the /ScriptFile switch.
Can I ask one other question?
This is a quest...
Diff script using sql compare command line
Is it possible to create a diff script using sql compare command line?
I want to create a upgrade script using sql compare command line for use in our CI process. I cant seem to get it to work. Are...