Its a powerfull and awesome tool! I'm using this tool since February, 2022. Its perfect. But I'm taking some little erros, its a little effotr in replace on notepad++, for example, in the "sql_type_mapping" section, I would like to transform timestamp to bytea and datetime2 to timestamptz, and I put this code below:
But, when I check the DDL file, the datatypes for theses coluns remaing timpestamp and datetime2, and I need put on notepad++ and replace manually.
Another problem is a comment in a column, when we have a coment like this: "--Default value for table AS 0", the part of AS 0 is broke and putted in the another line, and occuring sintax errors.
All erros are easy to fix, and I made this fix everyday, its simple to fix. If necessary, I can send you prints and files.
Its a powerfull and awesome tool! I'm using this tool since February, 2022. Its perfect. But I'm taking some little erros, its a little effotr in replace on notepad++, for example, in the "sql_type_mapping" section, I would like to transform timestamp to bytea and datetime2 to timestamptz, and I put this code below:
"timestamp" : "bytea", "datetime2" : "timestamptz",
But, when I check the DDL file, the datatypes for theses coluns remaing timpestamp and datetime2, and I need put on notepad++ and replace manually.
Another problem is a comment in a column, when we have a coment like this: "--Default value for table AS 0", the part of AS 0 is broke and putted in the another line, and occuring sintax errors.
All erros are easy to fix, and I made this fix everyday, its simple to fix. If necessary, I can send you prints and files.