Need help !

No topic. Everything you want to speak about. Please just stay courteous.

Moderators: Mug UK, Silver Surfer, Moderator Team

Post Reply
nagual
Captain Atari
Captain Atari
Posts: 437
Joined: Mon Sep 11, 2006 10:15 am
Location: Frankfurt am Main, Germany

Need help !

Post by nagual »

I have to migrate complete PostgreSQL database (tables, data, schemata...) to Microsoft SQL Server.
Since I do not have enough knowledge about PostgreSQL nor SQL server, question is how can I do that ?
Is there any tool to migrate complete database ?

I actually found one perfect tool for that, FullConverter, put price is.... :roll: :evil: :roll: :roll:

I tried with pg_dump, but I stucked on importing to SQL Server...I even don't know if pg_dump make everything select...

So, any help, link, step-by-step tutorial for idiots (me, of course!) is more then welcome !

Cheers! :cheers:
User avatar
mjvans
Atari maniac
Atari maniac
Posts: 82
Joined: Thu Dec 31, 2015 2:08 pm
Location: Netherlands
Contact:

Re: Need help !

Post by mjvans »

MS SQL server has many versions and flavours which have different tools.
Search for and download MS SQL Server Data Tools (SSDT)
It has the SQL Server Import and Export Wizard.
You probably need to install an odbc driver to connect to the PostgreSQL database.
Good luck.
Falcon030, Mega ST, 1040STfm, 800XL, Lynx, Jaguar
nagual
Captain Atari
Captain Atari
Posts: 437
Joined: Mon Sep 11, 2006 10:15 am
Location: Frankfurt am Main, Germany

Re: Need help !

Post by nagual »

mjvans wrote:MS SQL server has many versions and flavours which have different tools.
Search for and download MS SQL Server Data Tools (SSDT)
It has the SQL Server Import and Export Wizard.
You probably need to install an odbc driver to connect to the PostgreSQL database.
Good luck.
Thanks bro:-)

I found some scripts for PostgreSQL side, but don't have idea for SSDT tools:-)
Anyway, I'm downloading SSDT tools now (it's actally quite heavy, almost 1GB in download!) and tomorrow I try scripts any SSDT :-)

Cheers! :cheers:
nagual
Captain Atari
Captain Atari
Posts: 437
Joined: Mon Sep 11, 2006 10:15 am
Location: Frankfurt am Main, Germany

Re: Need help !

Post by nagual »

OK, problem solved, thanks @mjvans for tip and help:-)
Post Reply

Return to “Chat forum [ENG]”