SQL Packager 6 command line

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

SQL Packager 6 command line

Postby jpatches23 » Mon Aug 08, 2011 7:41 pm

Hi my company has recently acquired the SQLtool belt and I am trying to get the command line to work properly for the Packager. I am using version 6.4.0.8.

If I use the User interface I am able to generate a exe successfully. However, when I run the command line version I always get the same error using the following configuration file:

<?xml version="1.0"?>
<commandline>
<force/>
<verbose/>
<out>C:\\Users\\jmartin\\Desktop\\Test\\output.txt</out>

<makeexe></makeexe>
<name>SkyWebPremiumUpgrade</name>
<location>C:\\Users\\jmartin\\Desktop\\Test\\scripts\\</location>

<server1>SQLCOMPARE</server1>
<database1>DB</database1>
<username1>dbuser</username1>
<password1>password</password1>

<server2>SQLCOMPARE</server2>
<database2>DB 1.0.0.1522</database2>
<username2dbuser</username2>
<password2>password</password2>

<schemascript>C:\\Users\\jmartin\\Desktop\\Test\\scripts\\CreateDB.sql</schemascript>
<datascript>C:\\Users\\jmartin\\Desktop\\Test\\scripts\\DefaultData.sql</datascript>

<includeschema>Table</includeschema>
<includeschema>StoredProcedure</includeschema>
<includeschema>View</includeschema>
<includeschema>Function</includeschema>
<includeschema>Trigger</includeschema>

<includedata>Table:tblCountry</includedata>

</commandline>



Used mapping option 'IgnoreSpaces'
Used mapping option 'IncludeTimestamps'
Used mapping option 'IncludeIdentities'
Used Sql Option 'DisableKeys'
Used Sql Option 'DontOutputComments'
SQL Data Compare running with Mapping Option: IgnoreSpaces (OK).
SQL Data Compare running with Mapping Option: IncludeTimestamps (OK).
SQL Data Compare running with Mapping Option: IncludeIdentities (OK).
SQL Data Compare running with SQL Option: DisableKeys (OK).
SQL Data Compare running with SQL Option: DontOutputComments (OK).
SQL Data Compare running with Mapping Option: MissingFrom2AsInclude (OK).
Comparing database SQLCOMPARE.DB with database SQLCOMPARE.DB 1.0.0.1522...
Registering databases
Mapping
Comparing databases
Error: Object reference not set to an instance of an object.

NOTE:

I am able to generate the exe from the UI and the API. Is there anything I can do to troubleshoot this issue on my end? Also, if I try to use the following with the working project file I still get the above error:

sqlpackager.exe /project:"DB-1.0.0-Latest.sqlpkg"


As a confirmation as this working, here is the output from the exe with the successful data additions:

---------- Data SQL Summary ----------
Drop constraints from [dbo].[tblModelConfigurationPage]
Drop constraints from [dbo].[tblDeviceConstants]
Delete 1 row from [dbo].[tblVersion]
Delete 2 rows from [dbo].[tblRoleDescription]
Delete 9 rows from [dbo].[tblModel]
Update 6 rows in [dbo].[tblModel]
Add 2840 rows to [dbo].[tblInternational]
Add 4 rows to [dbo].[tblModel]
Add 17 rows to [dbo].[tblRoleDefault]
Add 2 rows to [dbo].[tblRoleDescription]
Add 6823 rows to [dbo].[tblTestPositions]
Add 277 rows to [dbo].[tblTestPositionsld]
Add 650 rows to [dbo].[tblTestTrack]
Add 1 row to [dbo].[tblVersion]
Add 2 rows to [dbo].[tblDeviceConstants]
Add 2 rows to [dbo].[tblModelConfigurationPage]
Add constraints to [dbo].[tblModelConfigurationPage]
Add constraints to [dbo].[tblDeviceConstants]
jpatches23
 
Posts: 2
Joined: Thu Aug 26, 2010 2:54 pm

Postby james.billings » Thu Aug 25, 2011 7:13 pm

I thought I'd just post here to follow up in case anyone else experienced this error.

We followed up with jpatches23 and narrowed the problem down to a bug in the Data Compare engine. This has now been resolved with a patch for SQL Packager. If you need to obtain this to get around this error, please contact support.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests

cron