| Author |
Message |
knowbell
Joined: 01 Jul 2010
Posts: 3
|
 Posted: Thu Jul 01, 2010 4:47 pm Post subject: Get Not-the-latest |
 |
|
We are using SVN as the repository.
Does SQL Source Control make it possible to "Get not-the-latest".
In other words, if I want to see the history of an object's changes, and pull in a version other than the latest, can I do that?
If not in the tool, then how could I use another tool (like Tortoise) or command line SVN to accomplish the same goal?
Note that I don't want to revert everyone to that version, just a single development environment.
Thanks. |
|
| Back to top |
|
 |
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Thu Jul 01, 2010 4:57 pm Post subject: |
|
|
We don't have this integrated into SSMS right now so the process in the meantime is:
1) Using Tortoise (for example) get the old tag/revision of the schema scripts folder to a temporary folder.
2) Load this as the source database in SQL Compare Pro as a scripts folder, and load your dev environment as the target.
3) Run the comparison and synchronization as you would normally do in SQL Compare.
Please let me know if this isn't straightforward.
Regards,
David Atkinson
Red Gate Software |
|
| Back to top |
|
|
bhoppe
Joined: 07 Jul 2010
Posts: 2
|
| Posted: Wed Jul 07, 2010 8:54 pm Post subject: Re: |
|
|
| David Atkinson wrote: |
We don't have this integrated into SSMS right now so the process in the meantime is:
1) Using Tortoise (for example) get the old tag/revision of the schema scripts folder to a temporary folder.
2) Load this as the source database in SQL Compare Pro as a scripts folder, and load your dev environment as the target.
3) Run the comparison and synchronization as you would normally do in SQL Compare.
Please let me know if this isn't straightforward.
Regards,
David Atkinson
Red Gate Software |
I'm trying to do the same thing with TFS. Can you confirm what I'm doing would be the correct procedure. First, I've created the link to TFS:
1) In Visual Studio, I've created a folder for the DB as $/ProjectA/Databases/TestDatabase
2) I've linked my TestDatabase in SQL Management Studio to this path and commited changes.
Back in Visual Studio, on the folder $/ProjectA/Databases\TestDatabase, I apply a label "Initial Commit".
Now, lets say down the road, after several changes and updates to the database, I want to get the inital database, I think this would be the procedure:
1) In Visual Studio, on the folder $/ProjectA/Databases\TestDatabase I get a specific version based on the label "Initial Commit".
2) Then in SQL Compare 8, I set the source to "Scripts Folder" and Target to "Database".
3)I specify my local path C:\ProjectA\Databases\TestDatabase as the scripts folder and the target to my server and the database I want to restore as.
4) Click "copy"
Is this correct?
Thanks,
Brandon |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Wed Jul 07, 2010 9:32 pm Post subject: |
|
|
Yes, that's right.
It involves a few more steps than we would have liked, but it's still something fairly understood and straightforward. We'll be adding better SSMS-integrated support for both getting a label to a dev DB and deploying from a label to a target.
David |
|
| Back to top |
|
|
|
|
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
