Doesn't synch data from commandline

Forum for users of SQL Packager database archive utility

Doesn't synch data from commandline

Postby Aline » Tue Jun 16, 2009 8:43 am

Hi
I'd like to generate a synch script for schema and data with packager commandline tool. I use an XML-File for parameters and options
Although I declare a specific TableName with:

<includedata>Table:test03</includedata>.

The insert statement is scripted only, if the table does not exist in the db for update. If it already exists, there's no data update.

If I try it with the GUI-Tool it works fine.

What might I have made wrong?

Thanks for your help

Aline
Aline
 
Posts: 12
Joined: Thu Apr 17, 2008 12:55 pm

Postby Aline » Wed Jun 17, 2009 8:02 am

I've got the following options:

<options>f,if,iw,ib,ift,ic,isi,t,ut,tclr,ddltd,oc</options>
Aline
 
Posts: 12
Joined: Thu Apr 17, 2008 12:55 pm

Postby Aline » Wed Jun 17, 2009 8:54 am

ok, I've found it:
I need the option
eid: IncludeIdentities
(Includes identity columns in the comparison. You cannot synchronize a view if it includes an identity column.)
Aline
 
Posts: 12
Joined: Thu Apr 17, 2008 12:55 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests

cron