Comments
Sort by recent activity
Sorry, Jobs aren't yet supported in SQL Compare. Regarding the comparison of DTS packages, you can download and use this tool for free: http://labs.red-gate.com/index.php/DTS_Package_Compare
David / comments
Sorry, Jobs aren't yet supported in SQL Compare. Regarding the comparison of DTS packages, you can download and use this tool for free:http://labs.red-gate.com/index.php/DTS_Package_Compare
David
We have a tool that can compare DTS packages linked from labs.red-gate.com
However, this doesn't compare SSIS packages.
SQL Compare doesn't currently compare Jobs, although this is something we could consider in a future version. Can I ask what you are trying to achieve?
Kind regards,
David Atkinson
Red Gate Software / comments
We have a tool that can compare DTS packages linked from labs.red-gate.com
However, this doesn't compare SSIS packages.
SQL Compare doesn't currently compare Jobs, although this is something we cou...
V1.0 will be TFS and SVN only, but you can vote for this feature at http://redgate.uservoice.com/forums/390 ... ?ref=title
and we will consider it for a future release.
Thanks!
David / comments
V1.0 will be TFS and SVN only, but you can vote for this feature athttp://redgate.uservoice.com/forums/390 ... ?ref=title
and we will consider it for a future release.
Thanks!
David
We don't put the blue icon on the index, but we should be putting this against the table.
Could you open up the SQL Source Control window and go to the commit changes tab? Is the table listed there?
David / comments
We don't put the blue icon on the index, but we should be putting this against the table.
Could you open up the SQL Source Control window and go to the commit changes tab? Is the table listed there...
There is a patch referenced here: http://www.red-gate.com/MessageBoard/vi ... php?t=9983
which may have the option you're looking for. Please give this a go and let us know if it meets your expectations.
Kind regards,
David Atkinson
Red Gate Software / comments
There is a patch referenced here:http://www.red-gate.com/MessageBoard/vi ... php?t=9983
which may have the option you're looking for. Please give this a go and let us know if it meets your expectat...
We've already had a number of SQL Compare users point it out to us, so we've built in a feature in SQL Compare that corrects the problem after it synchronizes!
David / comments
We've already had a number of SQL Compare users point it out to us, so we've built in a feature in SQL Compare that corrects the problem after it synchronizes!
David
Hmmm... maybe it was only fixed by Microsoft in SSMS 2008?
I've been trying to search in Google for "sp_rename bug SSMS fix" and suchlike to find a fix reference but to no avail. I did, however, come across a blog posting that explains the issue: http://www.adrianbanks.co.uk/?p=24
I think the conclusion is that the best approach is to avoid the rename feature. Red Gate's SQL Refactor has a 'Smart Rename' feature that does this properly (as well as renaming all references throughout the schema), although this is a commercial tool.
David / comments
Hmmm... maybe it was only fixed by Microsoft in SSMS 2008?
I've been trying to search in Google for "sp_rename bug SSMS fix" and suchlike to find a fix reference but to no avail. I did, however, co...
I don't think SQL Search is at fault here. I think you've stumbled across Microsoft's sp_rename bug whereby it doesn't update the syscomments entry with the new definition. I'm fairly sure that this was fixed in SSMS 2008. I thought this was fixed in a later edition of SSMS 2005, although I may be wrong there. Can you confirm which version you're using?
David Atkinson
Red Gate Software / comments
I don't think SQL Search is at fault here. I think you've stumbled across Microsoft's sp_rename bug whereby it doesn't update the syscomments entry with the new definition. I'm fairly sure that thi...
The SQL Source Control add-in's role is to allow you to easily commit and retrieve changed to and from source control. For the deployment/synchronization side you have to use SQL Compare / SQL Data Compare. In a future version these tools will be integrated much tighter together so you won't need to leave SSMS to achieve this. We eventually plan to allow the management of versions from within SSMS, such as tagging/labelling and getting these 'versions' from source control.
David Atkinson
Product Manager
Red Gate Software / comments
The SQL Source Control add-in's role is to allow you to easily commit and retrieve changed to and from source control. For the deployment/synchronization side you have to use SQL Compare / SQL Data...
Yes. The RedGateDatabaseInfo.xml file is also used by SQL Source Control. You will be able to 'get' this from source control to a folder and load this up the source data source in SQL Compare Pro. And yes this works with SQL Compare's command line.
In fact you should be able to prove this to yourself if you've installed the early access build. If it doesn't work, please let us know.
In a later version, we'll let you deploy any source controlled version of a database straight from SSMS. In the interim the workaround is to get it manually from source control to a folder and load it into SQL Compare. It's a couple of additional steps, but it's still pretty simple.
David / comments
Yes. The RedGateDatabaseInfo.xml file is also used by SQL Source Control. You will be able to 'get' this from source control to a folder and load this up the source data source in SQL Compare Pro. ...