• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

transferring database

 
evan theon
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i don't know if i'm right to post this topic here but...i can't find any other place more suitable
i want to transfer a SQL Server database to postgresql, but the tables' structure is different one to another, for example : in the sql server database i have a table named stock (id,name,price) but in the postgresql i want to have table stock(id,name,qty) and table price(price,discount). how to implement that?
thanks for any help you all provide...
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can generate script from sql server using any tool,then change in script and execute it on postgresql

Shailesh
 
evan theon
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for your help but there's 2 thing i want to ask :
1. when you said about generating a script, did you mean a programming scrip, sql server backup, or an excel/spreadsheet format of the tables?
2. if you meant generating a programming script from a sql server database, can you please mention the tool?
thanks a lot for your help, i really appreciate it
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by evan theon:
when you said about generating a script, did you mean a programming scrip, sql server backup, or an excel/spreadsheet format of the tables?


I mean to generate insert and create script that you can be executed on your database.I mean to use simple sql file no spread sheets.
but they can be a option for some approach


if you meant generating a programming script from a sql server database, can you please mention the tool?


you can use toad for Sql Server and it is free.

Toad wil help you generate scripts from sql server. but the generated script would be compatible to sql server, so you need to change them manually for postgresql.

If there is any other approach that would be also better


Shailesh
 
evan theon
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
OK thanks a lot let me try them...and i'll let you know if it's working
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic