Comments
Sort by recent activity
Great news! Your issue was fixed in the patch release v1.0.3.73, http://www.red-gate.com/messageboard/vi ... hp?t=11447. I will send you an email with the download details. / comments
Great news! Your issue was fixed in the patch release v1.0.3.73, http://www.red-gate.com/messageboard/vi ... hp?t=11447. I will send you an email with the download details.
It's currently not possible to ignore a certain folder within SQL Source Control.
Is it possible to move your "upgrade" folder to a higher level that is not within the SQL Source Control directory? Maybe you could have a structure like:
- Database - high level root folder
-- SchemaChanges - Point SQL Source Control here
-- Upgrade - Use for your patch files
Have you tried using SQL Compare to deploy your changes? You can use SQL Compare to compare a scripts folder (if you get a version using your source control system) or your development database to a target database (e.g., Test/QA). SQL Compare will show you all the differences. You can then automatically generate a syncrhonization script, which will create all the ALTER statements for you. It will take care of dependencies and order as well. This can be ran directly on the target db or it can generate a script that you can open in SSMS and review yourself before executing.
I hope this helps!
Stephanie M. Herr :-)
SQL Source Control Project Manager / comments
It's currently not possible to ignore a certain folder within SQL Source Control.
Is it possible to move your "upgrade" folder to a higher level that is not within the SQL Source Control directory?...
Hello,
Currently, you can only "link to a db already in source control" that was placed in source control by SQL Source Control. (This is for 5 users that each have their own dedicated db to link to the same centralized repository to share changes with each other. 1 user creates the link and the other 4 users "link to a db already in source control.") We have a specific format, so we currently can't link to existing "non-SQL Source Control" directories.
How did your database get into TFS initially? Were you using SQL Compare? Were you using the default file format? If so, there may be a workaround so that you can use your existing project and maintain all its history. Please contact support@red-gate.com if this is the case and you would like more information on linking to an existing SQL Compare repository.
If not, how did your db get into TFS? What process has your team been using?
We may consider integrating with VS 2010 DB Projects in a future version. Is this something that would interest you? This would allow users to work in SSMS or VS.
Thank you!
Stephanie M. Herr :-)
SQL Source Control Project Manager / comments
Hello,
Currently, you can only "link to a db already in source control" that was placed in source control by SQL Source Control. (This is for 5 users that each have their own dedicated db to link ...
Hello,
What source control system are you using?
It's best to do a SVN Checkout or a TFS Get Latest to a temporary location on your computer. You can then zip up the files and email that to support@red-gate.com. You may want to rename the zip to *.zip.txt, so email filters don't strip the attachment. When we get the file, we'll remove the .txt so we can see the zip contents.
Thank you!
Stephanie M. Herr :-)
Project Manager - SQL Source Control / comments
Hello,
What source control system are you using?
It's best to do a SVN Checkout or a TFS Get Latest to a temporary location on your computer. You can then zip up the files and email that to suppor...
Hello Jim,
This is very strange...
We are using SQL Compare to commit/get. SQL Compare sometimes requires the table to be rebuilt, but this doesn't sound like your situation.
Would you be able email us a copy of what's in source control and a SQL Compare snapshot of your database so we can reproduce the problem here? This will only be used for our internal testing.
Email: support@red-gate.com
Internal Reference Number: SOC-1235
Thank you!
Stephanie M. Herr :-)
Project Manager - SQL Source Control / comments
Hello Jim,
This is very strange...
We are using SQL Compare to commit/get. SQL Compare sometimes requires the table to be rebuilt, but this doesn't sound like your situation.
Would you be able ema...
Hello,
Thank you for reporting this issues. The first issue is definitely a bug. Our internal reference number is SOC-1163. This will not be fixed for v1, but you can just exit out of the help bubble.
For number 2, please vote/comment on these suggestions:
- A "Recent Messages" Button for Comments Like on TSVN
- Commit check in comment needs to be larger
Thank you!
Stephanie Herr :-)
Project Manager - SQL Source Control / comments
Hello,
Thank you for reporting this issues. The first issue is definitely a bug. Our internal reference number is SOC-1163. This will not be fixed for v1, but you can just exit out of the help b...
FYI - The first issue of the bubble being shown when canceling the link has been fixed in the v1.0.3.73 patch release. More info about this release is available at http://www.red-gate.com/messageboard/vi ... hp?t=11447. / comments
FYI - The first issue of the bubble being shown when canceling the link has been fixed in the v1.0.3.73 patch release. More info about this release is available at http://www.red-gate.com/messageb...
We have fixed this problem in the latest release. Please install http://downloads.red-gate.com/beta/SQLS ... 0.1.11.exe
Thank you to everyone who submitted an exception report! It helped us diagnose the issue and get this fix turned around very quickly.
Thanks again!
Stephanie M. Herr :-)
Project Manager - SQL Source Control / comments
We have fixed this problem in the latest release. Please install http://downloads.red-gate.com/beta/SQLS ... 0.1.11.exe
Thank you to everyone who submitted an exception report! It helped us diagn...
Hello,
In order to replicate this issue, could you please post or email support@red-gate.com the script for dbo.udf_UserDetails?
If by email, please reference our internal support number SOC-1197.
Thank you! Stephanie M. Herr :-)
Project Manager / comments
Hello,
In order to replicate this issue, could you please post or email support@red-gate.com the script for dbo.udf_UserDetails?
If by email, please reference our internal support number SOC-1197.
...
Hello,
Are you using Win7 x64? This is a known issue (SOC-675) on this OS...
The upgrade completed successfully, but you won't be able to use the new version until you restart SSMS. If you restart, and then select Help on the SQL Source Control tab > About, could you verify that your version is v0.4.1.2?
FYI - To reinstall, you can uninstall SQL Source Control from Add/Remove Programs and then download the latest version from the announcement posted at the top of this forum.
Thank you for the feedback. This is only an issue on Win7 x64, which we hope to fix at some point. On all other OSs, you are prompted to close SSMS yourself and you can not install until you do so. On Win7 x64, it just tries to close SSMS by itself without warning you.
It may be best on the "Check for Updates" to click the "more information" link. This will bring you to a page with the download link. You can then close SSMS and start the download. I know this is kind of an awkward workaround for now, but at least you can be sure that there won't be any problems with the update.
Thank you so much for reporting this! I hope this information helps.
Stephanie M. Herr :-)
SQL Source Control - Project Manager / comments
Hello,
Are you using Win7 x64? This is a known issue (SOC-675) on this OS...
The upgrade completed successfully, but you won't be able to use the new version until you restart SSMS. If you restar...