I have to migrate a current PostgreSQL database to MSSQL. But the binary format returned by PostgreSQL is in octal reprensentation .
So, Is there a simple way to convert (import) all the data for PostgreSQL to MSSQL, with a wizard (ie: OLE or ODBC), a free tool, etc, to a format understand by MSSQL.
Otherwise, I have thought to use BULK INSERT, but I do not know the format of the binary data used by this statement, is it OCTAL or HEXADECIMAL ??
Thanks
Note : Sorry for my english, it is not my first language.
So, Is there a simple way to convert (import) all the data for PostgreSQL to MSSQL, with a wizard (ie: OLE or ODBC), a free tool, etc, to a format understand by MSSQL.
Otherwise, I have thought to use BULK INSERT, but I do not know the format of the binary data used by this statement, is it OCTAL or HEXADECIMAL ??
Thanks
Note : Sorry for my english, it is not my first language.