Activity overview
Latest activity by shiftbit
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...
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 ...
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:
...
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...
SQL Compare - can I ignore Linked server requirement?
There is one stored procedure that requires a linked server and the deployment will fail.
I get an error similar to this:
[7391] The operation could not be performed because OLE DB provider "SQLNCL...
SQL Compare fails due to applying null constraint to table
I am trying to deploy changes FROM a live database, so my local instance that I got from a test server. I want to slap all the differences onto my local instance and start my changes from there. ...
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 ...
New to SQL Source Control - how to get initial source commit
Have SVN and a repository structure like so:
Tags
Branches
Trunk
How do I get a scripted copy of my database(s) into trunk?
Typically, trunk is reserved for merging changes INTO from other branches...