Create database in PostgreSQL from SQL Server

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

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


Updated February 25, 2016 03:02 AM

Updated August 08, 2016 08:02 AM

Updated February 22, 2019 15:06 PM

Updated May 22, 2018 20:06 PM