This week's book giveaway is in the Android forum.
We're giving away four copies of Android Programming: The Big Nerd Ranch Guide and have Bill Phillips & Chris Stewart on-line!
See this thread for details.
Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL server to postgre  RSS feed

 
Aditi agarwal
Ranch Hand
Posts: 225
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have a very large table of 1000 records in SQL server but now i want to transfer it to postgre SQL
anyone please ghelp me how can we do it

thank you
 
Swastik Dey
Rancher
Posts: 1784
14
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Using some java code?
 
Aditi agarwal
Ranch Hand
Posts: 225
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
no nothing simply using these softwares only if possible
 
Swastik Dey
Rancher
Posts: 1784
14
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Under Program files-MS-SQL server you should find an option as import and export data.
 
Rob Spoor
Sheriff
Posts: 20968
84
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
1000 and very large does not match in database land We have tables with millions of records at work. 1000 records is peanuts for good database servers.

MySQL Administrator can import from SQL Server. Doesn't PostgreSQL have something similar?
With SQL Server Management Studio you can export to several destination types. CSV is one of them (as Flat File Destination), perhaps you can use that as intermediate result. Unfortunately there is no ODBC destination. Perhaps you can find and install the necessary drivers to register PostgreSQL as a destination.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!