Dear ALL,
      We Need one solution for my problem.

      Actually we're using SQL server now.We thought of moving to Postgres.So we want to import all tables from SQL server to postgres,without any external Import & Export.

      We want to implement it through code only.

The Tools we're using is Struts & Hibernate.

If anyone have idea to implement this,Please share with me.

Thanks in advance

Rgds
Prabakaran

Hibernate i think it has a PostgresDialect.
Hope this helps....
You should use from the start DAO Pattern....that's the best ideea....

Rgds
LOOP

You can create a file to register two different drivers and open two connections.
After reading datas from SQL sever, doing the insert into PosgreSql right after.

Tien-Chih Wang

-- Meta Job Search Engine , Find your dream job --

http://www.onsofts.com/powerJobSearch.jsp