Red Gate forums :: View topic - Specify Tables Whose Data ... - Not All Tables Listed
Return to www.red-gate.com RSS Feed Available

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

Specify Tables Whose Data ... - Not All Tables Listed

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
MarkEaston



Joined: 09 Oct 2009
Posts: 2

PostPosted: Fri Oct 09, 2009 2:44 am    Post subject: Specify Tables Whose Data ... - Not All Tables Listed Reply with quote

We have just purchased and installed the latest version of Red Gate SQL Comparison Bundle.

I am trying to package a database upgrade, but all the data tables that need to be upgraded are NOT displaying. Some are though. I cannot determine why some are and some are not. For instance I have a table called ButtonLookup in the new db and also in the db to be upgraded. They are identical. The one in the new db has data and the one in the old db does not. So, this should result in data being inserted in to the table in the old db. But the table is not even listed in the data packager. Why is that?

Here are the structures of the two tables. They look identical to me ...

New DB:

USE [DR]
GO
/****** Object: Table [dbo].[ButtonLookup] Script Date: 10/09/2009 14:31:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ButtonLookup](
[PropertyID] [int] NOT NULL CONSTRAINT [DF_ButtonLookup_PropertyID] DEFAULT (0),
[TblName] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ButtonLookup_TblName] DEFAULT (' '),
[FldName] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ButtonLookup_FldName] DEFAULT (' '),
[IDFld] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ButtonLookup_IDFld] DEFAULT (' '),
[Depend] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ButtonLookup_Depend] DEFAULT (' ')
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


Old DB:

USE [QVisual58]
GO
/****** Object: Table [dbo].[ButtonLookup] Script Date: 10/09/2009 13:29:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ButtonLookup](
[PropertyID] [int] NOT NULL CONSTRAINT [DF_ButtonLookup_PropertyID] DEFAULT ((0)),
[TblName] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ButtonLookup_TblName] DEFAULT (' '),
[FldName] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ButtonLookup_FldName] DEFAULT (' '),
[IDFld] [varchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_ButtonLookup_IDFld] DEFAULT (' '),
[Depend] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ButtonLookup_Depend] DEFAULT (' ')
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
Back to top
View user's profile Send private message
MarkEaston



Joined: 09 Oct 2009
Posts: 2

PostPosted: Fri Oct 09, 2009 3:50 am    Post subject: Comparison Key Reply with quote

If the problem is with the lack of a comparison key ... then how in Packager do I specify a comparison key for such a table? I can see how to do this in the SQL Compare but not in SQL Packager.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Mon Oct 12, 2009 3:20 pm    Post subject: Reply with quote

Thanks for your post.

Your suspicions are correct, the problem is that there isn't a way to set a custom comparison key using SQL Packager 6. We will eventally add this facility (feature code: SPA-462), but it's not possible in the current version.

The best workaround we can ofer at present will be to create the migration scripts using SQL Compare and SQL Data Compare. You can then combine them into a single file, then package the script using SQL Packager.

I hope this is helpful.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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