File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes SQL server to postgre Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL server to postgre" Watch "SQL server to postgre" New topic
Author

SQL server to postgre

Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
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

Joined: Jan 08, 2009
Posts: 1449
    
    6

Using some java code?


Swastik
Aditi agarwal
Ranch Hand

Joined: Feb 23, 2011
Posts: 225
no nothing simply using these softwares only if possible
Swastik Dey
Rancher

Joined: Jan 08, 2009
Posts: 1449
    
    6

Under Program files-MS-SQL server you should find an option as import and export data.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19653
    
  18

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.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
 
subject: SQL server to postgre
 
Similar Threads
SQL command to show tables
how to retrieve data from postgresql using odbc driver
update query
query problem in jsp
Help to install PostgreSQL in Windows