Subject: How use two different database in one java program
Posted By: prabakarank@india.com Post Date: 8/12/2005 12:04:24 AM
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

Reply By: olupas Reply Date: 8/13/2005 1:00:35 PM
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


Reply By: meta_job_search Reply Date: 10/3/2005 1:07:22 PM
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

Go to topic 35257

Return to index page 461
Return to index page 460
Return to index page 459
Return to index page 458
Return to index page 457
Return to index page 456
Return to index page 455
Return to index page 454
Return to index page 453
Return to index page 452