Red Gate forums :: View topic - Unable to exclude tables from schema update
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Unable to exclude tables from schema update

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
alphalpha



Joined: 26 Jul 2007
Posts: 2

PostPosted: Thu Jul 26, 2007 8:56 pm    Post subject: Unable to exclude tables from schema update Reply with quote

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:

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
Back to top
View user's profile Send private message
alphalpha



Joined: 26 Jul 2007
Posts: 2

PostPosted: Fri Jul 27, 2007 11:12 am    Post subject: Reply with quote

This too was unhelpful...

5. <includeschema>Table</includeschema>
<includeschema>View</includeschema>
<excludeschema>Table:\[@PrimaryKey\]</excludeschema>
<excludeschema>Table:\[@LocalizationKey\]</excludeschema>
_________________
aLpHaLpHa
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group