Was the experience of porting the application from using MSSQL to PostgreSQL?

Hello colleagues in IT!

Did the task get rid of the super expensive Microsoft SQL Server. And the app uses this database to translate into PostgreSQL (or another database). Perhaps there is somewhere ODBC drivers for broadcast/conversion requests?

Maybe someone came across)))
July 8th 19 at 16:29
3 answers
July 8th 19 at 16:31
Look, if you don't like the price of MS SQL Server then the easiest way is to do so:
1) create a backup of your database at work
2) download MS SQL Server Express is the same DBMS that you have at work, only there is no planner backups, and many buns. But! she's a great running in production, we at work use the version of Express - it's free, is fast, configurable 10 times easier! And the transfer of the database will generally be a few clicks. Ie just take the same MS SQL (depending on what year you have, 2008, 2012..) and download the latest free version.
3) to login through Management Studio and into an empty database to fill in a copy of your working. all!
What Is PostgreSQL???? to migrate dB from SQL Server to Postgre need to be...funny. It is almost impossible. Take the same DBMS, the only free option! it will not be a service, but you don't need. and simply copy their database. Offer this option to the management.
Just, like Postgre and MS SQL was not originally designed for interoperability. And to realize this compatibility to take, was my experience...but for this purpose I wrote a Java application that was moved from MS SQL to MySQL data correctly. Ie the only way I know to migrate it in Postgre - to write the program. Hardly an ordinary system administrator with this pounding...and time will go a lot. Easier to do as I suggested above, use the free MS SQL. - breana_Fritsc commented on July 8th 19 at 16:34
Saw Your comment about the fact that the source code is not available. There is a variant really only one, as to change the connection string of the component in the program does not succeed, then the decision - only MS SQL free. During installation, specify the same name as Your current instance of SQL Server the same computer name. Username and password for the database server to do the same. And the program to connect without picking of sources. - breana_Fritsc commented on July 8th 19 at 16:37
: hi, here's the thing, express do not remove the data, I'm afraid we will lose only - Magdalena.Wym commented on July 8th 19 at 16:40
"Not remove" - it's like? and what version of MS SQL? - breana_Fritsc commented on July 8th 19 at 16:43
not remove - this means run into the limitations. Currently running version 2014 standard. Departed from ideas to translate to another platform, we have decided that it is not worth it. Maybe even would have lost in value - Magdalena.Wym commented on July 8th 19 at 16:46
July 8th 19 at 16:33
https://wiki.postgresql.org/wiki/Microsoft_SQL_Ser...

The experience was a translation from Oracle to psql but it was all relatively simple.
You offer a simple migration? The fact that the source code of the application is unavailable, and there just can't rewrite everything for a different driver - breana_Fritsc commented on July 8th 19 at 16:36
: wow, if the source code is not available then posuti options is not very much.... - breana_Fritsc commented on July 8th 19 at 16:39
If the source program working with a database that is not available, it is not a problem. - read my other response. - Magdalena.Wym commented on July 8th 19 at 16:42
July 8th 19 at 16:35
if the data is large, then formagined will not work: type "light" switch using the ORM could still Balk at raw sql queries, which, moreover, are tied to a DB - specific data types

and there are procedures/triggers, too DB-specific

and if you do not have Access, and SQL Server, it is unlikely that your app is easy and the data in it a little
The app itself uses Sql Server Standard (express do not pull)

Database size is not very large, about 20 GB, the maximum number of rows per table is about 500 million

About the procedures and triggers I am silent I do not understand what can help if the base itself is just cut from the app - breana_Fritsc commented on July 8th 19 at 16:38
to help anything, just if they have - they also need to be competent to carry
it is necessary to look / compare data types - breana_Fritsc commented on July 8th 19 at 16:41
: well, it would be the reason for the article) - Magdalena.Wym commented on July 8th 19 at 16:44

Find more questions by tags SQLSQL ServerPostgreSQLWindows Server