Unable to exclude tables from schema update

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Unable to exclude tables from schema update

Postby alphalpha » Thu Jul 26, 2007 8:56 pm

I have a reference DB that contains a couple of tables that are used only for primary key management during database builds. These tables are not intended to be included in the DB instances that I upgrade using SQLPackager. I use the sqlpackager command line tool to build the upgrade scripts, but I can't seem to configure the /excludescheme and /includeschema arguments to exclude these tables.

I use an XML argument file for sqlpackager command-line tool. As for the ex/includeschema arguments, I've tried all of the following:

1. <excludeschema>Table:@PrimaryKey</excludeschema>
<excludeschema>Table:@LocalizationKey</excludeschema>
<includeschema>Table</includeschema>
<includeschema>View</includeschema>

2. <excludeschema>Table:@PrimaryKey</excludeschema>
<excludeschema>Table:@LocalizationKey</excludeschema>
<includeschema>View</includeschema>

3. <excludeschema>Table:@.*</excludeschema>
<includeschema>Table</includeschema>
<includeschema>View</includeschema>

4. <includeschema>Table</includeschema>
<includeschema>View</includeschema>
<excludeschema>Table:@.*</excludeschema>

In every case, in the sqlpackager output, I see:

Code: Select all
Object type Name                      DB1 DB2
---------------------------------------------
Table       [dbo].[@LocalizationKey]  >>
Table       [dbo].[@PrimaryKey]       >>
Table       [dbo].[ActionItem]        >>
Table       [dbo].[ActionItemComment] >>
etc


The first two lines items need to disappear. SQL code for creating these tables in the target DB is also included in the scripts produced by sqlpackager.

What do I do to exclude these tables from the package scripts?
aLpHaLpHa
alphalpha
 
Posts: 2
Joined: Thu Jul 26, 2007 8:35 pm

Postby alphalpha » Fri Jul 27, 2007 11:12 am

This too was unhelpful...

5. <includeschema>Table</includeschema>
<includeschema>View</includeschema>
<excludeschema>Table:\\[@PrimaryKey\\]</excludeschema>
<excludeschema>Table:\\[@LocalizationKey\\]</excludeschema>
aLpHaLpHa
alphalpha
 
Posts: 2
Joined: Thu Jul 26, 2007 8:35 pm


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests