Activity overview
Latest activity by AdamY
That did the trick, @DanC. Thanks! We may not use this setup, but I like knowing the options and pros/cons of each. / comments
That did the trick, @DanC. Thanks! We may not use this setup, but I like knowing the options and pros/cons of each.
I see that my settings for <SchemaModelSubFolder>, <SyncToOfflineSchemaModelBySchema>, and <SyncToOfflineSchemaModelObjectTypes> are all commented out, but look like this: <SyncToOfflineSchemaModelBySchema>True</SyncToOfflineSchemaModelBySchema> <SchemaModelSubFolder>Schema-Model</SchemaModelSubFolder> <SyncToOfflineSchemaModelObjectTypes>Table;Assembly;Contract;Default;EventNotification;FullTextCatalog;FullTextStoplist;MessageType;PartitionFunction;PartitionScheme;Queue;ServiceBinding;Role;Route;Rule;Schema;SearchPropertyList;Service;Sequence;Synonym;User;UserDefinedType;XmlSchemaCollection</SyncToOfflineSchemaModelObjectTypes> I guess those are defaults. I'll try uncommenting them and making sure the programmable objects are in the SyncToOfflineSchemaModelObjectTypes setting and see how it goes. I'll update this thread once I've had a chance to try it. / comments
I see that my settings for <SchemaModelSubFolder>, <SyncToOfflineSchemaModelBySchema>, and <SyncToOfflineSchemaModelObjectTypes> are all commented out, but look like this:<SyncToOfflineSchemaModelB...
For anyone reading this, I posted a follow-up question here regarding schema-model behavior when using the ScriptInMigrations option. / comments
For anyone reading this, I posted a follow-up question here regarding schema-model behavior when using the ScriptInMigrations option.
Schema-Model behavior when using ScriptInMigrations option
According to this Redgate documentation, using the ScriptInMigrations option in the ProgrammableObjectHandling setting has this effect:This effectively disables the programmable object feature and...
danielpottenger said:
The execution policy will need to be set to at least 'RemoteSigned' in order to import and run our scripts. Restricted doesn't allow the execution of any scripts, so it is likely an error in our release notes.
Thanks, @danielpottenger. I bet the release notes were supposed to say "RemoteSigned", not "Restricted". I'll give it a shot and reply if it still is not working. / comments
danielpottenger said:
The execution policy will need to be set to at least 'RemoteSigned' in order to import and run our scripts.Restricted doesn't allow the execution of any scripts, so it i...
I tried to post this as a "Question" but it kept saving in Drafts and when I edited the draft it would only let me submit it as a "Discussion". Sorry. / comments
I tried to post this as a "Question" but it kept saving in Drafts and when I edited the draft it would only let me submit it as a "Discussion". Sorry.
PowerShell error "running scripts is disabled on this system"
I'm brand new to SQL Change Automation and am to the point where I'm trying to run some of the PowerShell scripts on my machine. I installed SQL Change Automation PowerShell 4.3.20267.22294 via the...
Thank you, Dan! That is very helpful. It also helps our team understand the pros and cons of using the migrations-based approach vs state-based vs hybrid. And now I can see that using a hybrid approach combined with the ScriptInMigrations option might be a good option for us. / comments
Thank you, Dan! That is very helpful. It also helps our team understand the pros and cons of using the migrations-based approach vs state-based vs hybrid. And now I can see that using a hybrid appr...
Thank you, David. We have been playing with the hybrid approach for a few days, but it seems like duplicate effort. We make changes, check them in to Git via SSC. Then we have to do more steps in SCA to create scripts and check those in to Git. Two tools to manage and the object scripts end up in Git twice. Thus, we are currently leaning toward the migrations-based approach only and avoiding the use of SSC (which is a bummer because I love that tool). / comments
Thank you, David. We have been playing with the hybrid approach for a few days, but it seems like duplicate effort. We make changes, check them in to Git via SSC. Then we have to do more steps in S...
How to customize migration scripts in state-based approach
I've been reading and watching many of the docs/videos about SCA as we try to use SCA for the first time. But it has been tough. The latest question is about using custom migration scripts with the...