Comments
Sort by recent activity
Hi Jason54,
Thanks for reporting this issue.
The "Failed to locate the target table" is a known issue. We think it's because there are slight changes between the db and the repo and we're not sure which version you are at. The best thing to do for now is to create a new db and link that and then pull the latest from source control into that new db, if that is possible. I realize this means your new db won't have the data from your existing db...
We are working on fixing this FK Issue though. Our internal reference number is SOC-803.
There are some known issues if you have different db versions that are attached to the same repo. Things like using a SQL 2008 datatype and committing to a repo which a SQL 2005 db pulls from would fail. I don't think this is the issue in this case, but I just wanted to make sure you were aware of this. Also, we do not official support Express Editions. We don't load in SS 2005 Express at all.
Thank you!
Stephanie M. Herr :-) / comments
Hi Jason54,
Thanks for reporting this issue.
The "Failed to locate the target table" is a known issue. We think it's because there are slight changes between the db and the repo and we're not sure...
This is definitely not good in the long run, but I'm glad you're able to use SQL Source Control against your development db for now. We don't recommend using SQL Source Control with your live/production database because SQL Source Control is more for your day to day db development and committing these changes to source control so there is a history of every change along with who made the change, when, and why. When it comes time to push your changes to your other environments (test, QA, staging, production), then you can use SQL Compare Pro to generate the synchronization script to bring your target database up to date. There is a 14 day free trial of SQL Compare on our web site at http://www.red-gate.com/products/SQL_Compare.
There are some known issues of linking a database to source control if it doesn't match exactly. Do you know how your development db differed from your live/production db? Did one of the tables in the FK relationship match live/production exaclty and the other one have a slight change?
Our internal reference number for this issue is SOC-803. / comments
This is definitely not good in the long run, but I'm glad you're able to use SQL Source Control against your development db for now. We don't recommend using SQL Source Control with your live/prod...
Thanks for sending in the error report and posting this issue here.
I think you see an error like "Nothing to Commit" because the dbo schema shows up on the Commit list, but then it doesn't actually recognize this change so it thinks there is nothing to commit.
We are currently working this issue. Our internal reference number is SOC-799.
For now, please just ignore this on your commit list. If there are multiple objects to commit, it will NOT error because there will be something else to commit.
There is a manual workaround if you want to get this object off your commit list and you don't expect it to change much. (If it changes a lot, you'll have to re-do this workaround each time.) Workaround: Manually create the schema file if you are familiar with TSVN:
1. Check out the repository to a working folder (You can right-click on the URL on the Setup Tab and copy it.)
2. In the Security\Schemas directory, create a text file and rename it to dbo.sql
3. Paste in the text from the db version diff pane on the Commit Tab (You can right-click on the diff pane Select All, right-click again and copy.)
This was:
-- Permissions
GRANT VIEW DEFINITION ON SCHEMA:: [dbo] TO [cy_reader]
GO
4. Remove the "-- Permissions" and the empty line from the top of the file
5. Save the file
6. Use TSVN to Add and Commit this change back to the repository
7. In SSMS, refresh your commit list
The dbo schema should no longer appear on the commit list. / comments
Thanks for sending in the error report and posting this issue here.
I think you see an error like "Nothing to Commit" because the dbo schema shows up on the Commit list, but then it doesn't actuall...
Thanks for letting us know how you fixed it. The 3 places you mentioned make sense. I'll add this workaround to your issue and we'll see if there's a way we could prevent it from having this problem in the first place. / comments
Thanks for letting us know how you fixed it. The 3 places you mentioned make sense. I'll add this workaround to your issue and we'll see if there's a way we could prevent it from having this prob...
Thank you so much for including the stack track and the code for the function. We were able to replicate your issue. We are looking into a fix for this now. Our internal reference number is SOC-800. / comments
Thank you so much for including the stack track and the code for the function. We were able to replicate your issue. We are looking into a fix for this now. Our internal reference number is SOC-...
2 Things:
1) Could you please check for updates to make sure you have the latest version? To do this, please click Help > Check for Updates... near the Red Gate logo on the SQL Source Control tab. The latest version is 0.3.0.1, which was released on March 8th.
2) Could you please email SQLSourceControlSupport@red-gate.com with the file located at C:\Users\danny\AppData\Local\Red Gate\SQL Source Control 0\Transients-TFS\ae8a33f1-d80e-4c6b-a86f-1b9076626d12\Tables\dbo.E_Sold_Policies.sql? This way, we can try to reproduce it locally so we can provide a fix for you. Our internal reference number for this issue is SOC-802. / comments
2 Things:
1) Could you please check for updates to make sure you have the latest version? To do this, please click Help > Check for Updates... near the Red Gate logo on the SQL Source Control tab....
Hi Roman,
No problem. I'm glad you were able to find this on our Suggestion Forum. We are currently working on the Revert functionality. If this is important to you, you can comment/vote at http://redgate.uservoice.com/forums/390 ... ?ref=title
Thank you! / comments
Hi Roman,
No problem. I'm glad you were able to find this on our Suggestion Forum. We are currently working on the Revert functionality. If this is important to you, you can comment/vote at http...
One more thing that I wanted to mention... In this example, you want to revert/undo a dropped table. In a future SQL Source Control version, you will be able to do this, but it will only bring back the table's schema and not the data that was in the table. Does that make sense?
SQL Source Control is not a replacement for database backups. After reverting the schema, you could use our SQL Data Compare to synchronize the data in that table from a recent backup or from another dev/test/production db. Since it's a development db, you may not be concerned about the data anyways.
In a future version of SQL Source Control, we are considering giving users the option to also source control data. This would be useful for static/reference/lookup data that is part of the application and not really recommended for transactional data. If this data was in source control, then this should be revertable as well. This is a ways out right now... / comments
One more thing that I wanted to mention... In this example, you want to revert/undo a dropped table. In a future SQL Source Control version, you will be able to do this, but it will only bring ba...
SQL Source Control currently doesn't have the ability to ignore objects.
Please vote/comment on this suggestion at http://redgate.uservoice.com/forums/390 ... ?ref=title to help us prioritize future features.
The best thing to do now is:
1) Sort the Commit List by Object Name
2) Use your mouse and shift key to highlight all the objects that start with DYN*
3) Unclick on one of the rows, which will unselect all of the highlighted objects
4) Commit your other objects, which are still selected
If you only made one change, you could also use the checkbox in the column header to unselect all the objects in the commit list, and then only select the one object you want to commit.
You can also do this by right-clicking on the object in the Object Explorer and selecting Commit. This will bring you to the Commit tab with only the one object selected.
I hope these tips help for now... :-) / comments
SQL Source Control currently doesn't have the ability to ignore objects.
Please vote/comment on this suggestion athttp://redgate.uservoice.com/forums/390 ... ?ref=title to help us prioritize future...
If you are also looking for GIT Support, please vote/comment on our Suggestion Forum at http://redgate.uservoice.com/forums/390 ... ?ref=title. / comments
If you are also looking for GIT Support, please vote/comment on our Suggestion Forum at http://redgate.uservoice.com/forums/390 ... ?ref=title.