Problem with Initial Static Data Check-In

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Problem with Initial Static Data Check-In

Postby AndrewJacksonZA » Fri Dec 03, 2010 8:41 am

With my initial static data check-in, no data could be found to update another database with. I'm using SVN.

Steps to reproduce:
  • Database CPU is under source control.
  • Select static data from tables Registers and Pipelines.
  • When committing the static data, realise that you've made a mistake and only want static data from Registers, so you only commit Registers.
  • Go to the "Static data to source control..." screen and deselect Pipelines.
  • Go to the commit tab and see that there are no changes to commit into the source control repository.
  • Create new database ALU.
  • Link ALU to the SVN repository.
  • Get the latest changes.
  • Notice that there is no data in the list of changes, and there is no data available in subsequent refreshes of the list of changes.


My RedGateDatabaseInfo.XML file has the following entry:
Code: Select all
  <DataFileSet>
    <Count>0</Count>
  </DataFileSet>


When I've played around some more, I got:
Code: Select all
  <DataFileSet>
    <Count>3</Count>
    <DataFile>dbo.Registers.sql</DataFile>
    <DataFile>dbo.Pipelines.sql</DataFile>
    <DataFile>dbo.Cores.sql</DataFile>
  </DataFileSet>
which is correct. I could get this data into the ALU database OK.
AndrewJacksonZA
 
Posts: 17
Joined: Wed May 05, 2010 11:09 am
Location: Johannesburg, South Africa

Can't reproduce

Postby sherr » Mon Dec 06, 2010 2:08 pm

Andrew and I have both tried to reproduce this, but could not. If anyone else experiences this problem, please get in touch.

For the v2.0.0.37 EA release, getting the schema and data for the same table is a 2 step process. Only the schema will appear at first on the get list. Once you get the schema, then you can get the data.
Thank you!
Stephanie M. Herr :-)
Delivery Product Manager
sherr
 
Posts: 126
Joined: Thu Mar 19, 2009 12:45 pm
Location: Cambridge


Return to SQL Source Control 2 EAP

Who is online

Users browsing this forum: No registered users and 0 guests