search

dalibo / sqlserver2pgsql

Migration tool to convert a Microsoft SQL Server Database into a PostgreSQL database, as automatically as possible
http://dalibo.github.io/sqlserver2pgsql
GNU General Public License v3.0
515 stars 117 forks source link

Ignore GRANT statements #115

Closed alchemistmatt closed 5 years ago

alchemistmatt commented 5 years ago

This change ignores statements like the following in the script generated by SQL Server Management Studio

GRANT SELECT ON [dbo].[T_ParamValue] TO [WebUser] AS [dbo]
GRANT UPDATE ON [dbo].[T_ParamValue] TO [WebUser] AS [dbo]
GRANT VIEW DEFINITION ON [dbo].[V_MgrState] TO [Mgr_Config_Admin] AS [dbo]

I realize that we can prevent these from being included when the script is generated from SSMS, but I figured, we may as well ignore them too.

alchemistmatt commented 5 years ago

I was planning to make a separate pull request for commits 4f6500d, a36c4bb, and fbd3280

GitHub decided to lump them into this pull request. Looks like I need to make separate branches with these commits, and try again.

alchemistmatt commented 5 years ago

Superseded by #116