Comments
Sort by recent activity
We're having a look at this issue now. Can I check which versions of SQL Source Control and SQL Prompt you both have? You may be able to resolve the problem by updating to the latest versions of both of these other tools. If you've got a support contract I also advise that you send an email in to support@red-gate.com with these details as this will help us keep track and keep you updated more easily. / comments
We're having a look at this issue now. Can I check which versions of SQL Source Control and SQL Prompt you both have? You may be able to resolve the problem by updating to the latest versions of bo...
There's a 'show this screen on startup' check box on the Projects list (which you can get to from the folder button on the toolbar), which you can check if you want to be shown a list of projects / be able to open a project on launch rather than be presented with your last-opened project or a brand new project. / comments
There's a 'show this screen on startup' check box on the Projects list (which you can get to from the folder button on the toolbar), which you can check if you want to be shown a list of projects /...
https://documentation.red-gate.com/display/SQT3/Adding+a+database+to+SQL+Test describes the steps that SQL Test takes on installing the framework, which is the part which needs elevated permissions. You should be able to have someone with the appropriate permissions install the framework onto the database, after which the developers just need to be able to create and execute stored procedures and CLR in the appropriate schemas. / comments
https://documentation.red-gate.com/display/SQT3/Adding+a+database+to+SQL+Test describes the steps that SQL Test takes on installing the framework, which is the part which needs elevated permissions...
This is definitely a feature we're actively considering. You might want to request it on https://redgate.uservoice.com/forums/141379-sql-compare so that we can see additional demand for it, which will have input to our prioritization decisions. / comments
This is definitely a feature we're actively considering. You might want to request it on https://redgate.uservoice.com/forums/141379-sql-compare so that we can see additional demand for it, which w...
Could you try out the latest version, and see if that has fixed the problem? We've recently done some work in that area, so it might well have done so; if not, I might be able to do more with a more up to date script. / comments
Could you try out the latest version, and see if that has fixed the problem? We've recently done some work in that area, so it might well have done so; if not, I might be able to do more with a mor...
Which version of SQL Compare 13, and which version of SQL Server? I can't reproduce the problem on 13.7.16 (the latest frequent releases build) and SQL Server 2019. We recently made a change to role membership addition to use the ALTER ROLE ADD MEMBER syntax where possible, so I'd expect an up to date script to be using that rather than sp_addrolemember. / comments
Which version of SQL Compare 13, and which version of SQL Server? I can't reproduce the problem on 13.7.16 (the latest frequent releases build) and SQL Server 2019. We recently made a change to rol...
Yes - this is normal behaviour when we have to 'rebuild' or 'unbind' objects in the middle of a deployment - e.g. a schemabound function that depends on something that you've changed. If there weren't any changes to that object, we will put it back the way it was by the end of the deployment, but we have to modify it briefly in the middle of the deployment to perform the requested actions. / comments
Yes - this is normal behaviour when we have to 'rebuild' or 'unbind' objects in the middle of a deployment - e.g. a schemabound function that depends on something that you've changed. If there were...
You can connect to your servers from the SQL Backup UI to check their licensing state - they won't use up your license allocation until you install server components and activate the license on the server. / comments
You can connect to your servers from the SQL Backup UI to check their licensing state - they won't use up your license allocation until you install server components and activate the license on the...
If you go to the 'Options' tab when you're setting up the project, there is a check box labelled 'Show identical values in results'. Checking this check box will provide you with a list of identical records when you click on the identical tab after performing the comparison.
To get a comparison result grid out of the program, you can go to Print Preview and use the toolbar button with a document and green disk icon to select what format you would like to export your grid of results in. (We know that this is a rather hidden feature at the moment and have plans to work on exposing it better in the next version.)
I hope this helps resolve your concerns, but do ask for more advice if you're still having problems [image] . / comments
If you go to the 'Options' tab when you're setting up the project, there is a check box labelled 'Show identical values in results'. Checking this check box will provide you with a list of identica...
Everything else should be there (apart from identical objects) - it's just Static Data that behaves differently. / comments
Everything else should be there (apart from identical objects) - it's just Static Data that behaves differently.