Comments
Sort by recent activity
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...
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.
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...
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...
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...
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.
Redgate gave us a 1-year license for SCA to try it out, but afterward we have to pay more $$ since SQL Source Control doesn't allow custom migration script without the backdoor work-around (which might not work for long?). Seems sneaky to move a feature from one product to a more expensive product. And I'm having problems using/understanding SCA with SSC - but that's a different topic. / comments
Redgate gave us a 1-year license for SCA to try it out, but afterward we have to pay more $$ since SQL Source Control doesn't allow custom migration script without the backdoor work-around (which m...
Me too! What the heck?! And my Tab History button is gone. I used that a lot. My recent queries are no longer available. But if Tab History is part of SQL Prompt, then I guess that would make sense. / comments
Me too! What the heck?! And my Tab History button is gone. I used that a lot. My recent queries are no longer available. But if Tab History is part of SQL Prompt, then I guess that would make sense.
The release notes say .NET Framework 4.7.2 or higher is required. I installed .NET Framework 4.8 just now but still have the SQL Prompt error. / comments
The release notes say .NET Framework 4.7.2 or higher is required. I installed .NET Framework 4.8 just now but still have the SQL Prompt error.