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.
Please sign in to leave a comment.
It can be done only table-by-table.
Press F5 on the root table and choose the target.
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?
This feature is 'where hosted' and 'dialect' agnostic. Do you see that tables in the database tree of your MariaDB data source?
I have disconnected the MariaDB and reconnected it and now I can copy the data.
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.
Looks like https://youtrack.jetbrains.com/issue/DBE-11933
Please increase you MAX LOB size as described