• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Best way to copy data from one database to another

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

Please suggest me the best approach to copy / load data from one database(PROD) to another database (TEST).

Each table is having bulk data (millions of records).

Thanks,
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Likes 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Export the data from PROD to a file using the export features of your database. Import the data from that file to TEST using the database's import features. Normally JDBC shouldn't be involved at all, unless you're using a database which doesn't have import and export capabilities.
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If one or both of the DBs are lacking in built-in tools, the phrase you're looking for is "ETL tool" for Extract, Transform, Load. Lots of 3rd party tools are available which should cover any combination of DBs.
 
Pranav Kristam
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for the reply. yes I can export and import all data to a file except BLOB using TOAD and i am looking for an option how to export and import BLOB data type.
 
reply
    Bookmark Topic Watch Topic
  • New Topic