wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
72 stars 3 forks source link

Support for security policies #64

Closed ghost closed 2 years ago

ghost commented 2 years ago

Hi are there any plans (or already exists) to add support for security policies of SQL server? When using automation scripts for comparing two databases, they are not added as part of migration.

wise-coders commented 2 years ago

Is this about CREATE SECURITY POLICY? Can you please check the Schema / Synchronization Settings/ Pre and Post Synchronization Scripts? Does this help?

ghost commented 2 years ago

CREATE SECURITY POLICY

Yes that's the one.

Can you please check the Schema / Synchronization Settings/ Pre and Post Synchronization Scripts? Does this help?

Do you mean that it should work and I'm just missing an option to select, or that I should write a custom handler within Pre/Post Synchronization scripts

wise-coders commented 2 years ago

Right now they are not included in the reverse engineer. We plan to add them in the next releases. The Pre/Post Sync Scripts are a workaround.

ghost commented 2 years ago

Thanks for the clarification