Red Gate forums :: View topic - RedGateDatabaseInfo.xml Keeps Re-Adding Unlinked Data Files
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

RedGateDatabaseInfo.xml Keeps Re-Adding Unlinked Data Files

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JackAce



Joined: 08 Jul 2011
Posts: 37

PostPosted: Tue Mar 20, 2012 1:17 am    Post subject: RedGateDatabaseInfo.xml Keeps Re-Adding Unlinked Data Files Reply with quote

(this is regarding SQL Source Control 2.x)

We were versioning the contents of a static lookup table, and then we removed the link, but a reference still shows up in the RedGateDatabaseInfo.xml file. This makes Red Gate Compare try to delete all the records in the table which causes a foreign key constraint error when synchronizing.

If I manually edit the RedGateDatabaseInfo.xml file and check it in, we can use Red Gate Compare to deploy the scripts, but the next time I make a change and check it in via SSMS/Red Gate Source Control, it increments the DataFileSet/Count value and re-adds the DataFile containing the *_Data.sql file.

All developers are working in "dedicated" mode with their own copies of the database in question (as far as I know).

How do we prevent Red Gate Source Control from readding this data file?
Back to top
View user's profile Send private message
csmith



Joined: 30 Jun 2011
Posts: 114
Location: Cambridge

PostPosted: Tue Mar 20, 2012 5:36 pm    Post subject: Reply with quote

Hi

I think the issue you describe is the same as this one. The conclusion was that we did not think the failure to update RedGateDatabaseInfo.xml would cause a problem. However, you have found this is not ther case.

What version of SQL Data Compare you are using? As we believe the latest version should not exhibit that behaviour (although the RedGateDatabaseInfo.xml will still not be updated by SQL Source Control).

Best regards,
Chris
_________________
Chris Smith
Project Manager
Deployment Manager
Back to top
View user's profile Send private message
JackAce



Joined: 08 Jul 2011
Posts: 37

PostPosted: Tue Mar 20, 2012 6:09 pm    Post subject: SQL Compare Version Reply with quote

We are using SQLCompare.exe version 9.0.0.79. I verified this locally and on our build machine.
Back to top
View user's profile Send private message
csmith



Joined: 30 Jun 2011
Posts: 114
Location: Cambridge

PostPosted: Thu Mar 22, 2012 7:12 pm    Post subject: Reply with quote

Hi

Thanks for that. I've got a few more questions to clarify what's happening:

1. Can I confirm that you are using SQL Compare to deploy your schema changes rather than SQL Data Compare to deloy static data changes?
They are two distinct products and SQL Compare will not try to compare data changes.
2. When you unlinked the static data tables, did you commit that change to SQL Source Control? As the unlink operation should appear in the commit tab.
3. Are you making a change to the schema for the static lookup table that has showed up when doing your initial comparison? If so, is it possible this change could cause data loss?

Thanks,
Chris
_________________
Chris Smith
Project Manager
Deployment Manager
Back to top
View user's profile Send private message
JackAce



Joined: 08 Jul 2011
Posts: 37

PostPosted: Fri Mar 23, 2012 5:30 pm    Post subject: Reply with quote

You're right, we are using SQL Data Compare to deploy. We are using SQL Data Compare version 9.0.0.117.

We definitely unlinked the tables via Red Gate SQL Source Control. There is no longer a MyTable_Data.sql file in the Data folder, but the information still exists (and keeps getting repopulated) in the RedGateDatabaseInfo.xml file.

The schema of this table hasn't been touched for a while.
Back to top
View user's profile Send private message
csmith



Joined: 30 Jun 2011
Posts: 114
Location: Cambridge

PostPosted: Fri Mar 23, 2012 6:04 pm    Post subject: Reply with quote

Hi

Looking at the records for a similar problem, I think this may have been solved in a later version of Data Compare.

Can you upgrade to the latest version of Data Compare v9? I believe its full version number 9.1.0.365 and you should be able to get it from here:
ftp://support.red-gate.com/patches/SQL_Data_Compare/SQL%20Data%20Compare_9.1.0.464.zip

Best regards,
Chris
_________________
Chris Smith
Project Manager
Deployment Manager
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