Create database in PostgreSQL from SQL Server

by Fran.J   Last Updated May 15, 2019 16:06 PM - source

An application is being made in .NET to register (inventory) databases (from SQL Server, PostgreSQL, MySQL and Oracle), users and credentials in SQL Server tables, what we want to do in addition is that this application does not only register, but also generate the DDL statement for the creation of the same depending on the database system, this is simple, what I can not find is how to execute these statements from SQL Server to another database administration system.

In summary I would like to know if it is possible to execute DDL statements in PostgreSQL or another manager from SQL Server, or it is necessary to create a connection of the application directly with the database in question (PostgreSQL, MySQL, Oracle). Although there is a way to do it, I would like to save the time of downloading the drivers and implementing them in the application.

Note: We already have the PostgreSQL and MySQL drivers for queries from SQL Server via linkservers, but I can not find a way to create a database in the same way.

Any suggestion would be very useful to me.

Thank you.



Related Questions


MySQL vs PostgreSQL (w.r.t database administration)

Updated February 25, 2016 03:02 AM

How to find missing number

Updated August 08, 2016 08:02 AM

Deterministic vs Nondetermistic

Updated February 22, 2019 15:06 PM

SQL Vs MySQL vs MongolSQL

Updated May 22, 2018 20:06 PM