|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
March 24th, 2008, 12:52 AM
|
|||
|
|||
Data transfer from one database to other
hi
i have my data in firebird database.I need to transfer that data in DB2 on click of a button.The data is in large amount so i used data transfer by XML file. In that XML file i need to create structure for all the tables which will take lots of time.Is there any other solution for passing the data. Thanks in advance.
|
|
#2
March 24th, 2008, 03:13 AM
|
||||
|
||||
|
Data can be passed with any opensource or commercial ETL tool, you can even use MsAccess for that (look at my site linked in the signature for an example).
I'm afraid you'll have to recreate table structures by hand, or at least by checking and "translating" DDL statements.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Data transfer from one database to other |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
