Add option to convert Identity columns to "GENERATED ALWAYS AS IDENTITY"

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

Add option to convert Identity columns to "GENERATED ALWAYS AS IDENTITY" #118

Closed alchemistmatt closed 3 years ago

alchemistmatt commented 5 years ago

This change converts Identity columns to Generated Always As Identity columns instead of creating sequences. Apologies in advance for all of these pull requests Use them if you want, or ignore/close them. I've changed enough code now that I suspect my version will soon diverge too much from yours.

madtibo commented 3 years ago

I rebased this PR (#150).

:heart: Thank you very much @alchemistmatt for the nice job on sqlserver2pgsql!! :heart: