Comments
Sort by recent activity
Issue has been resolved - No answers required / comments
Issue has been resolved - No answers required
Thanks Eddie, The issue was that SQL CLR wasn't enabled on the instance. Cheers Neil / comments
Thanks Eddie,The issue was that SQL CLR wasn't enabled on the instance.CheersNeil
OK, I'll download SCA and try that / comments
OK, I'll download SCA and try that
Having thought more about this overnight it appears that the powershell cmdlet is working on a migrations basis rather than a state basis. We've always gone down the state approach but seeing failures due to EXEC sp_refreshview, DROP INDEX and ALTER TRIGGER implies a migrations approach does it not. The thing is, none of the individual scripts in the scripts folder use those T-SQL commands so it must be the cmdlet that is doing something. When powershell commences execution the following appears in the execution window:- Invoke-DlmDatabaseSchemaValidation, DLM Automation 2.0.32.1199, Copyright © Red Gate Software Ltd 2014-2018 In trial: expires 2019/11/13 09:06:48 +00:00 Validating project 'scripts folder 'D:\ManzenDatabaseTrunk''.
Cleaning database 'Blankdb' on server 'TTS******TEST' My assumption is that 'Cleaning database ' is a process that ensures the db is blank before execution of any CREATE scripts for the individual objects. We know that following completion of the cmdlet that 'Blankdb' is still empty of any objects contained in the scripts folder but expect that as the whole idea is to create and then remove a scratch copy of the database from the scripts. We're still no closer to resolving this however. / comments
Having thought more about this overnight it appears that the powershell cmdlet is working on a migrations basis rather than a state basis.We've always gone down the state approach but seeing failur...
A. SQL Clone / comments
A. SQL Clone
I have a continuing issue with tabs opening but not reconnecting when I start up SSMS. I have "Automatically reconnect restored tabs" checked. All tabs are connected via Windows Authentication. When I last restarted SSMS I had 27 tabs open only 7 of which reconnected. Connections would all have been to the same database. I have also noticed that some of the tabs have the same name. Some of these are connected whilst others are not. Each window has different content. SSMS: - [image] SQL Prompt: - [image] [image] / comments
I have a continuing issue with tabs opening but not reconnecting when I start up SSMS.I have "Automatically reconnect restored tabs" checked. All tabs are connected via Windows Authentication.When ...
I concur with your thoughts Steve and have had the same email conversation with Simon Galbraith. For a product that Redgate promote as part of the automation suite it should be supported and developed further. / comments
I concur with your thoughts Steve and have had the same email conversation with Simon Galbraith. For a product that Redgate promote as part of the automation suite it should be supported and develo...
This issue eventually resolved itself in that after I'd left DLM Dashboard running on a PC and came back to it some 90-120 mins later the UI was responsive and I could name the Schema and make a comment. The appearance of the application hanging would definitely appear to be related to the number of objects contained within the change, mine was in excess of 400. If you leave it long enough it will eventually sort itself out. To avoid the issue we're now updating the schema on a more regular basis which just adds more n.nn.nn versions prior to a full version upgrade being identified. / comments
This issue eventually resolved itself in that after I'd left DLM Dashboard running on a PC and came back to it some 90-120 mins later the UI was responsive and I could name the Schema and make a co...
Hi Richard, This is an extremely poor state of affairs when for a couple of years or more Redgate were actively encouraging us all to monitor database drift with DLM Dashboard. Indeed, on this page on your website, https://www.red-gate.com/products/dlm/dlm-automation/ you still mention DLM Dashboard, meaning that would be purchasers would not be aware that the product isn't supported. I am flabbergasted that there has been no communication from Redgate about the change of status of DLM Dashboard and from a company whose products I respect and use daily I am deeply disappointed. I'm now in a situation where DLM Dashboard doesn't function correctly and Redgate are effectively saying "tough". Do you have a formal mechanism to raise a complaint to you CEO? Edit: - The DLM Dashboard product page at https://www.red-gate.com/products/dlm/dlm-dashboard/ makes no mention of the fact that the product is no longer under active development and is not being supported. We have an active support package for all our Redgate products. Section 5.4 of the EULA (taken from https://www.red-gate.com/products/dlm/dlm-dashboard) states "You accept that, although we will use reasonable endeavours to solve problems identified by purchasers of the
Support Package, the nature of software is such that no guarantee can be provided that any particular problem
will be solved." I'd submit to you that Redgate haven't used reasonable endeavours to solve this problem as you haven't used any endeavours at all. / comments
Hi Richard,This is an extremely poor state of affairs when for a couple of years or more Redgate were actively encouraging us all to monitor database drift with DLM Dashboard.Indeed, on this page o...
Is someone from Redgate going to respond or do I have to raise a support ticket? / comments
Is someone from Redgate going to respond or do I have to raise a support ticket?