Rollback a committed link of static data

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

Rollback a committed link of static data

Postby bjordan » Tue Jul 19, 2011 11:03 am

Hi,

I've linked a couple of tables and committed my changes to source control. One of the tables has over 100,000 rows. Now all teams members are unable to update their local repo. They either get an error or the "Calculating Changes" process is taking forever. I've unlinked them locally, and am now trying to commit the unlink, but again the "Calculating Changes" process is taking forever.

Is there a quick way to unlink and remove this data from source control, directly in the repo perhaps?

Cheers
Barry
bjordan
 
Posts: 2
Joined: Tue Jul 19, 2011 10:55 am

Found Solution

Postby bjordan » Thu Jul 21, 2011 12:10 pm

Hi,

In the end I manually edited the _data files directly in the central repository, leaving only a couple of insert statements in them. I then committed those and updated my local repository directly, using the command line. I then got latest using SQL Server Management Studio and the update was v quick.

Barry
bjordan
 
Posts: 2
Joined: Tue Jul 19, 2011 10:55 am


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests