Activity overview
Latest activity by Nick_Foster
Perfect, thank you. Looks like I already had the root cert, but was missing the intermediate. Once I had that Change Automation installed just fine. Cheers. / comments
Perfect, thank you. Looks like I already had the root cert, but was missing the intermediate. Once I had that Change Automation installed just fine.Cheers.
Certificate is invalid: RedGate.SqlChangeAutomation.VisualStudio.vsix
I've tried installing this multiple times and although it installs ok into Sql Management Studio, it doesn't show up in Visual Studio 2019 Enterprise. The machine is a Windows Server 2019 VM behin...
@Garth_Martin We used the pre-deployment script to create a stub with just enough of the related db to validate the build. Something like: /*To get around the cross database queries we need to scaffold out the archive database*/ IF (DB_ID('Archive') IS NULL) BEGIN -- create the database CREATE DATABASE [Archive] END GO -- create the objects that we need for validation IF (OBJECT_ID('Archive.dbo.Alerts') IS NULL) BEGIN CREATE TABLE [Archive].[dbo].[Alerts] ( [AlertID] [INT] NOT NULL, [ObjectID] [INT] NOT NULL, ...
/ comments
@Garth_Martin We used the pre-deployment script to create a stub with just enough of the related db to validate the build. Something like:/*To get around the cross database queries we need to scaff...
Thanks for the help Sergio, most apprciated. It's a shame I can't just ignore the Windows users, I would love to control the SQL logins with the Change Automation project. I don't suppose I could raise it as a feature request for future versions? [image] / comments
Thanks for the help Sergio, most apprciated. It's a shame I can't just ignore the Windows users, I would love to control the SQL logins with the Change Automation project.I don't suppose I could r...
I'm assuming "Ignore user's permissions and role memberships" will apply to all users, not just the Windows ones. Is that correct. / comments
I'm assuming "Ignore user's permissions and role memberships" will apply to all users, not just the Windows ones. Is that correct.
So I've been playing with the filters in SQL Compare 14 in order to create something I can use in the Change Automation projects. When I exclude users from the comparison they are still included in the role definitions, for example <div>-- Role</div><div>CREATE ROLE [EbCollSqlgen]</div><div>AUTHORIZATION [dbo]</div><div>GO</div><div>ALTER ROLE [EbCollSqlgen] ADD MEMBER [ATTENDA-HQ\EbCollSqlgen]</div><div>GO
</div>Do these not get validated then? Will the deploy still fail if the role membership includes Windows users not in the current domain? / comments
So I've been playing with the filters in SQL Compare 14 in order to create something I can use in the Change Automation projects.When I exclude users from the comparison they are still included in ...
Hi Sergio, Thanks for the suggestion. Is there a straight-forward way of excluding only Windows users from the Change Automation project? I would really like to keep the SQL logins in source control so I can keep tabs easily on permissions. For example on the primary database I'm working on there are 10 Windows users and 40 sql logins to keep track of. Cheers, Nick / comments
Hi Sergio,Thanks for the suggestion. Is there a straight-forward way of excluding only Windows users from the Change Automation project? I would really like to keep the SQL logins in source contr...
Hi Sergio, Yes, our new dev/test environment is being built in it's own AD Domain. This gives us problems in that the Windows users on the production database will be like Prod\JohnSmith and in the test database will be Test\JohnSmith. We are using SQL Change Automation projects. / comments
Hi Sergio,Yes, our new dev/test environment is being built in it's own AD Domain. This gives us problems in that the Windows users on the production database will be like Prod\JohnSmith and in the...
How do I deploy a database into a different Active Directory domain?
So I have been charged with setting up a new dev/test environment for our development team. For whatever reason this environment is not in the same Active Directory domain as the production enviro...
PeterDanielsCRB said:
What if I hacked it by creating a __MigrationLog table and copying the data over from the dev DB?
That's what I've been doing to get new projects up and running. Clone the prod database to a test server, run the deploy on the clone and then copy the __MigrationLog and __SchemaSnapshot tables to the production box. It's awkward but better than redeploying all the views and sprocs to a busy production server. / comments
PeterDanielsCRB said:
What if I hacked it by creating a __MigrationLog table and copying the data over from the dev DB?
That's what I've been doing to get new projects up and running. Clone...