postgresql to sql server

Classic Servoy
1

hi!
is it simple to create a database backup file (table schemas) of a postgresql and then dumping into an sql server database? we have our development database in postgresql but what if the client has an existing sql server and would like to use it instead? will this work?

2

Hi Rogel,

Short answer: No, it’s not simple.
Long answer: Even when dumping into plain SQL files there are always syntax differences or even datatypes that other vendors don’t use. There are however tools around that help you convert schemas from one vendor to another and some also a way to move the data over. There are plenty of Open Source and commercial offerings. Depending on your need and budget you can decide which one is best for you.
I suggest you google around a bit.

Hope this helps.

3

Rogel

You could try creating an empty SQLserver database on the clients Server then use Servoy’s solution export/import (allowing DB changes) to do most of the hard work for you.

HTH

4

We have build a solution, in Servoy, that you can use to dump data from one server to another.

we needed this to migrate (LARGE) databases from Sybase to postgreSQL, a 2GB Sybase database, was converted to postgreSQL in 15 minutes… , like it! :-)

We are thinking of open source it on ServoyForge. (after some clean up! ;-) )

5

Harjo:
We are thinking of open source it on ServoyForge. (after some clean up! ;-) )

What is there to think about? ;)
Just let me know when you need a project space on ServoyForge. The info we need can be found here.

6

Harjo:
We have build a solution, in Servoy, that you can use to dump data from one server to another.

we needed this to migrate (LARGE) databases from Sybase to postgreSQL, a 2GB Sybase database, was converted to postgreSQL in 15 minutes… , like it! :-)

We are thinking of open source it on ServoyForge. (after some clean up! ;-) )

cool! i will be honored to have a copy.

thanks!

7

Hi Rogel,

a commercial solution can be found here: Data Pump for SQL Server | SQLManager
this tool will not only copy your data, but also recreate your DB, tables, indices, etc. (all optional of course)

I used the version to go from Sybase to PG (>12GB of data), and I love it!

8

yeah, when it works, it’s oke, but it’s a pain to get it stable, even the version that you download now from there website is not working!!
You still need a seperate build, to get rid off all kind of crashes… :cry:

Also big blobs does the programm still crash.