cloning database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: cloning database

  1. #1
    Join Date
    Mar 2007
    Posts
    20

    cloning database

    Hi,

    please tell me the cloning process, my client is using sql sever'05 wit oracle 9i database.

    how i clone the entire database in another location. plz help me and give the total script for the job.

    thanking u.

    sunil

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Are you aware you are talking about two different RDBMS technologies?

    Be good to your client and hire a DBA -or two.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Are you cloning from SQL Serer to Oracle or from Oracle to SQL Server? No one will know how to clone your data without knowing anything about what you are doing. How many tables, how much data, how often do you need to clone, etc...? Both databases have tools that will help you to create flat files with your data, and then import into the other database. You can also use Oracle Heterogeneous services to create a direct connection between the databases and then set up replication between the two.

    But you won't get someone to figure this out for you.
    this space intentionally left blank

  4. #4
    Join Date
    Oct 2008
    Location
    Johannesburg,South Africa
    Posts
    3

    Thumbs up

    dude, seriously... i agree with PAVB, but to be more diplomatic...
    google it... there's tons of documentation onm the net, try Metalink as well...
    good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width