Comments
Sort by recent activity
Can you provide examples of what you mean by "maintenance"? / comments
Can you provide examples of what you mean by "maintenance"?
If I understand correctly, you've chosen to add json as the value of extended property. SQL Compare will compare the value of the extended property, and therefore will just regard your json as text. It doesn't know that this is json, and therefore can't pick out specific elements. / comments
If I understand correctly, you've chosen to add json as the value of extended property. SQL Compare will compare the value of the extended property, and therefore will just regard your json as text...
I can't reproduce your issue, at least not on the most recent version of Flyway Desktop. I set the option in Flyway Desktop: schema model screen/static data and comparisons/comparison options/Ignore system named constraint and index names = checked
This set the following in my flyway.toml file (it might be worth converting your flyway-dev.json to toml just in case this helps)
[redgateCompare.sqlserver.options.ignores] ignoreSystemNamedConstraintAndIndexNames = true And In the Generate migrations screen, it correctly ignores the constraint names. / comments
I can't reproduce your issue, at least not on the most recent version of Flyway Desktop. I set the option in Flyway Desktop: schema model screen/static data and comparisons/comparison options/Ignor...
@RyuseiSakamoto All functionality in Flyway Community that you are able to access doesn't require a paid license. If you try to use any features that require a paid license, the software will inform you and you will be prompted to start a trial. / comments
@RyuseiSakamoto All functionality in Flyway Community that you are able to access doesn't require a paid license. If you try to use any features that require a paid license, the software will infor...
Thanks. So you need some sort of domain mapping ability, rather like is already possible for schema mapping?
It would be interesting to hear from anyone else with a similar issue.
I've noted this as a feature request.
Kind regards,
David Atkinson
Red Gate Software / comments
Thanks. So you need some sort of domain mapping ability, rather like is already possible for schema mapping?
It would be interesting to hear from anyone else with a similar issue.
I've noted this a...
Hi,
Thanks for your request. could you please post an example of what is happening how and what you would like to see? Which objects are affected?
Thanks,
David Atkinson
Red Gate Software / comments
Hi,
Thanks for your request. could you please post an example of what is happening how and what you would like to see? Which objects are affected?
Thanks,
David Atkinson
Red Gate Software
Interesting. What is the consequence of two users changing the same query? / comments
Interesting. What is the consequence of two users changing the same query?
Object locking is to prevent multiple users changing the same objects in a shared database context. In dedicated databases, this can't happen. What were you hoping it would prevent? / comments
Object locking is to prevent multiple users changing the same objects in a shared database context. In dedicated databases, this can't happen. What were you hoping it would prevent?
That was exactly how I had envisaged it. Not everyone will want to see this, so it would need to be an option. Also, it is possible that some will want to use one extended property for Descriptions and one for casual Notes, in which case we could provide somewhere to change which extended property is displayed on the object.
Thanks for raising this. I definitely think there's good mileage in this idea.
David / comments
That was exactly how I had envisaged it. Not everyone will want to see this, so it would need to be an option. Also, it is possible that some will want to use one extended property for Descriptions...
Admittedly it's quite hard to find in SSMS. If you right click the object in Object Explorer, select Properties, then select Extended Properties. Type MS_Description as the Name and your text in the Value.
Alternatively if you own SQL Doc, you can use this to easily input descriptions.
MS_Description is the Microsoft standard way of documenting SQL Server objects. We put functionality in SQL Prompt that allows you to view the MS_Description simply by hovering over the object in your SSMS editor window.
David / comments
Admittedly it's quite hard to find in SSMS. If you right click the object in Object Explorer, select Properties, then select Extended Properties. Type MS_Description as the Name and your text in th...