Transfer Data between Servers (MS SQL to PostgreSQL)

Answered

Is there a way for me to transfer or just ETL data from an MS SQL Server to a PostgreSQL server via DataGrip? I hate the idea of having to save tables and databases as import files and then change my connection and do imports.

6 comments
Comment actions Permalink

It can be done only table-by-table.

Press F5 on the root table and choose the target.

0
Comment actions Permalink

Hi Maxim,
I want to do the same, but from a local MSSQL server to a remote MariaDB server. The remote server tables do not show when I press F5. I only get my local datasources (MSSQL and PostgreSQL)

Does this main it will only work for local datasources? Or is just MariaDB not supported in this?

0
Comment actions Permalink

This feature is 'where hosted' and 'dialect' agnostic. Do you see that tables in the database tree of your MariaDB data source?

0
Comment actions Permalink

I have disconnected the MariaDB and reconnected it and now I can copy the data.

0
Comment actions Permalink

It did copy some data, but it looks like large text fields (varchar(max) on MSSQL -> MEDIUMTEXT on MariaDB) is not copying all the data. It only copies about the first 4700 characters.

0
Comment actions Permalink

Looks like https://youtrack.jetbrains.com/issue/DBE-11933
Please increase you MAX LOB size as described

0

Please sign in to leave a comment.