Comments
Sort by recent activity
I think I found the option I needed - "Dont use transactions", this let me get past the one problem stored procedure thats using a linked server, but if its not configured on my machine, then the change deployment fails.
In this casae, Im trying ti update my local instance with the changes in the DB on the server, and to take/override what I have with everything from that instance. / comments
I think I found the option I needed - "Dont use transactions", this let me get past the one problem stored procedure thats using a linked server, but if its not configured on my machine, then the c...
Ok, I managed to finish earlier today getting several databases scripted and placed into our subversion repository. Using a combination of SQL Compare and SQL Source Control, I did the following:
- created empty local databases
- use sql compare to basically re-recreate the database that I want to version and use as a starting point (the production db server).
- once I had local instance copies of the databases I wanted to version, I linked each one in turn with a path in the main branch of svn (trunk).
- since this was new, all the changes were "add", so i committed the changes and now I had these db's scripted and in subversion! success, a starting point for further development.
- now I branched trunk to create a development branch.
- checked out this development branch, made a small update, and committed the changes.
- re-linked the database that was associated with the change, then did a "get latest" from within SSMS and the source control tab. A conflict was detected and I took the version in SVN.
- now my local instance had the update.
im cooking now! / comments
Ok, I managed to finish earlier today getting several databases scripted and placed into our subversion repository. Using a combination of SQL Compare and SQL Source Control, I did the following:
...
David,
Thanks for the reply. That is what i am about to do this morning. Putting our sql objects under source control is a top priority of mine, so I can keep track of changes. I will report back when Im finished. / comments
David,
Thanks for the reply. That is what i am about to do this morning. Putting our sql objects under source control is a top priority of mine, so I can keep track of changes. I will report back...
Ok, now that just posted all of the above, I think my problem was the subversion repository browser. I closed it down and re-opened, and my test branch had a scripted copy of my database.
So, now I think I see the path I need to take to get my database(s) into source.
Make a backup copy of each of my database(s)
restore them locally
link each to a path in Trunk in subversion, each in their own folder
this should create the scripted versions in trunk
THEN I can branch from there to make changes in the branch...err I think
So lets say I create a branch to work on, and I have a local instance, how can I point this local instance at my branched code? / comments
Ok, now that just posted all of the above, I think my problem was the subversion repository browser. I closed it down and re-opened, and my test branch had a scripted copy of my database.
So, now ...
I am having the same problem. I have a local instance that was linked to a path in a subversion repository. After committing the changes in to this branch, I unlink and pointed it to a different location. When starting, it gets stuck at 10% and goes no further.
note: I had originally pointed the link to trunk, because I had used sql compare to bring down all the differences between our production db and my local instance. Then I committed these into trunk for a starting point.
Then I branched this into a new branch. This new branch is what I am trying to link to. / comments
I am having the same problem. I have a local instance that was linked to a path in a subversion repository. After committing the changes in to this branch, I unlink and pointed it to a different ...
I replied to an older thread, but I am using SSC and am running into a problem with linking.
from the other thread (sorry about the double post)
I have a local instance that was linked to a path in a subversion repository. After committing the changes in to this branch, I unlink and pointed it to a different location. When starting, it gets stuck at 10% and goes no further.
note: I had originally pointed the link to trunk, because I had used sql compare to bring down all the differences between our production db and my local instance. Then I committed these into trunk for a starting point.
Then I branched this into a new branch. This new branch is what I am trying to link to. / comments
I replied to an older thread, but I am using SSC and am running into a problem with linking.
from the other thread (sorry about the double post)
I have a local instance that was linked to a path in...