Comments
Sort by recent activity
(Later) reinstalled the SCA in SSMS in its latest version. This time it worked when one hit 'refresh'. and produced a scripts directory just like the good old days. I generally use SQL Compare for this, but this could be handy. / comments
(Later) reinstalled the SCA in SSMS in its latest version. This time it worked when one hit 'refresh'. and produced a scripts directory just like the good old days. I generally use SQL Compare for...
I tried clicking the link but that is talking about Visual Studio, which I don't use. I have SQL Change Automation in SSMS. Does this do the same thing? I've tried starting a workspace and putting a development database in it but I can't find a way of generating the object-level scripts (I think you call this the offline schema model) / comments
I tried clicking the link but that is talking about Visual Studio, which I don't use. I have SQL Change Automation in SSMS. Does this do the same thing? I've tried starting a workspace and putting...
I'd still be grateful to know whether SCA will remain eclectic, and support conventional object-level scripts as well as migration scripts? / comments
I'd still be grateful to know whether SCA will remain eclectic, and support conventional object-level scripts as well as migration scripts?
Ah. Maybe I've misunderstood something. So what term now distinguishes the two parts of the tool, and tells me that, for example, SQLcmd variables aren't supported for what I'm trying to do? / comments
Ah. Maybe I've misunderstood something. So what term now distinguishes the two parts of the tool, and tells me that, for example, SQLcmd variables aren't supported for what I'm trying to do?
I was commissioned by a well-known UK industrialist to create a nonsense-generator based on the style and content of Jeremy Corbyn's published writings. No kidding. I based it on a Christmas article I once had published on Simple-talk / comments
I was commissioned by a well-known UK industrialist to create a nonsense-generator based on the style and content of Jeremy Corbyn's published writings. No kidding. I based it on a Christmas articl...
I've got a lot of SCA PowerShell scripts that I use that I can add. It would be a useful resource. I like the idea of the rollback scripts. / comments
I've got a lot of SCA PowerShell scripts that I use that I can add. It would be a useful resource. I like the idea of the rollback scripts.
Which of the current snippets could be safely sent for recycling? / comments
Which of the current snippets could be safely sent for recycling?
I have a assigned a local windows user account to run the service. It looks from what you say, as if SQL Clone will only work if all the resources, SQL Server and network, are within a Windows Domain. Is that correct? / comments
I have a assigned a local windows user account to run the service. It looks from what you say, as if SQL Clone will only work if all the resources, SQL Server and network, are within a Windows Doma...
I get the formatter to work happily if I comment out the '--At WSLSource;' so I reckon the bug is there. It isn't your source which seems fine. I have put an entry in sys.servers for WSLSource to test this.
GO
CREATE TABLE tmpRptInvoiceHistory
(
BookingNo INT,
ReportDate DATETIME
);
GO
DECLARE @sql VARCHAR(MAX);
SELECT @sql = 'Select 1,''1 Jan 2008''';
INSERT INTO tmpRptInvoiceHistory(BookingNo, ReportDate) EXEC(@sql); --At WSLSource; / comments
I get the formatter to work happily if I comment out the '--At WSLSource;' so I reckon the bug is there. It isn't your source which seems fine. I have put an entry in sys.servers for WSLSource to ...
Yes, the problem is getting it in one file. If you are handy with PowerShell, you can automate the process to do several databases on one server in one go. I give a link to an article I wrote to show how to do several databases on one server. As far as I remember, it is possible to extend the code to do several servers but each server would be written to a different 'site'. I hope that wouldn't matter! https://www.red-gate.com/hub/product-learning/sql-doc/how-to-document-multiple-sql-server-databases-using-sql-doc-and-powershell / comments
Yes, the problem is getting it in one file. If you are handy with PowerShell, you can automate the process to do several databases on one server in one go. I give a link to an article I wrote to sh...