Delete deprecated XML File System.String[] from repository

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Delete deprecated XML File System.String[] from repository

Postby isme » Tue Nov 13, 2012 11:52 am

I'm using SQL Compare to script out a new object into version control.

I compared a database to my local scripts folder and selected one stored procedure for 'deployment'.

The Files tab lists two file actions:

Modify fileRedGateDatabaseProperties.xml
Create file Stored Procedures\\dbo.uspWidgetDelete.sql


The Warnings tab lists two informational messages:

Severity: Information
Title: If using source control please add new XML file C:\\fakepath\\WidgetDB\\RedGateDatabaseProperties.xml to the repository
----------------------------------------------------
Severity: Information
Title: If using source control you can delete deprecated XML File System.String[] from the repository
----------------------------------------------------


I understand the first message. The RedGateDatabaseProperties.xml file should always be part of the repository.

I don't understand the second message. There is no file called System.String[] in the repository. Coincidentally, System.String[] is the name of a .NET type.

What does the second message mean?
Last edited by isme on Tue Nov 13, 2012 1:38 pm, edited 1 time in total.
isme
 
Posts: 81
Joined: Tue Jun 12, 2012 1:49 pm
Location: Edinburgh

Postby isme » Tue Nov 13, 2012 1:36 pm

I think the deprecated file is RedGateDatabaseInfo.xml.

Perhaps the second informational message should instead look like this:

Severity: Information
Title: If using source control you can delete deprecated XML File C:\\fakepath\\WidgetDB\\RedGateDatabaseInfo.xml from the repository
----------------------------------------------------


Am I correct to assume that RedGateDatabaseProperties.xml is a replacement for RedGateDatabaseInfo.xml?

Perhaps just one informational message explaining that one file is to replace the other would be more helpful.

My local scripts folder is also an svn working copy. I used the svn status command to show all the changes made by SQL Source Control. The output looks like this:

C:\\fakepath\\WidgetDB>svn status
! RedGateDatabaseInfo.xml
? Stored Procedures\\dbo.uspWidgetDelete.sql
? RedGateDatabaseProperties.xml


The output shows that SQL Compare created two new files, Stored Procedures\\dbo.uspWidgetDelete.sql and RedGateDatabaseProperties.xml, and deleted one file, RedGateDatabaseInfo.xml.

The .sql file represents the change I intended to make, and the .xml files are metadata for the Red Gate tools.
isme
 
Posts: 81
Joined: Tue Jun 12, 2012 1:49 pm
Location: Edinburgh

Postby Brian Donahue » Fri Nov 16, 2012 11:48 am

Thanks for your submission. I have logged bug SC-6112 with our development team.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Fri Nov 16, 2012 12:17 pm

I just created a new link to source control and it creates RedGateDatabaseInfo.xml, so this should be the current file. I can't find any references to the "Properties" file in any past support cases or anywhere else.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests