![]() ![]() The “–source-ds-type” and “–target-ds-type” flags denote the database type and must be one of SQLpipe’s supported systems.We would run the following command: sqlpipe transfer \ -source-ds-type "mssql" \ -source-hostname "your-mssql-hostname" \ -source-port 1433 \ -source-db-name "your-mssql-db-name" \ -source-username "your-mssql-username" \ -source-password "your-mssql-password" \ -target-ds-type "postgresql" \ -target-hostname "your-postgresql-hostname" \ -target-port 5432 \ -target-db-name "your-postgresql-db-name" \ -target-username "your-postgresql-username" \ -target-password "your-postgresql-password" \ -target-schema "your-postgresql-schema-name" \ -target-table "name-of-table-to-insert-into" \ -overwrite \ -query "select * from dbo.users" Let’s say we want to transfer a table called “users”, in the schema “dbo”, from SQL Server to PostgreSQL. Running a transfer is accomplished with the “sqlpipe transfer” command and passing some information via flags. The next step is gathering the following information for both SQL Server and PostgreSQL: If installation is successful, the version command will print something like this: Git hash: d3b390c Human version: 1.0.0 Step 2 – Gather connection information Run the version command to check installation success:.Grant execution permission to run with:.Download the pre-built binary from our downloads page with your browser or command-line tool like curl.If you would like step by step installation instructions, check out our installing SQLpipe page. ![]() You can get it from the SQLpipe downloads page. SQLpipe is available as an executable program and has no dependencies. ![]() This tutorial will show you how to use the command-line tool to transfer data from SQL Server to PostgreSQL. The command-line tool is the easiest way to get started, but the server grants additional features like an API, a UI, user authentication, and horizontal scalability. The command-line tool is excellent for running ad-hoc transfers between two databases, while the server is intended to be part of a recurring ETL process. SQLpipe is a free, open-source tool that can transfer the result of a query from one database to another. ![]()
0 Comments
Leave a Reply. |