D
D
dobriykot2011-03-30 11:35:19
PostgreSQL
dobriykot, 2011-03-30 11:35:19

Converting a PostgreSQL dump to MSSQL 2008?

I downloaded the dump of the Musicbrainz database and I want to import it into MSSQL 2008, which I picked up on the local machine.
Is it possible? How to do? I did not find anything on the Internet, except for paid converters, which, as I understand it, need an installed PostgreSQL server.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
H
hexen, 2011-03-30
@dobriykot

You get the PostgreSQL base script, and try to correct this script and run it in MSSQL.
First, create an empty database in MsSQL, and then start this experiment.
There will be a few changes in the structure, which unfortunately will have to be manually tweaked.
Especially if you use stored procedures.
If you have only tables in the database, then the procedure is greatly simplified.
In general, this will take some time.

R
rasa, 2011-03-30
@rasa

Also, for a while, to raise the pgsql-server on this machine is not an option?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question