|
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
|