+ Reply to Thread
Results 1 to 4 of 4
  1. 10-16-2008 05:32 AM #1
    sunilvmahanti
    sunilvmahanti is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 10-17-2008 10:07 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,488
    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.
    Reply With Quote Reply With Quote
  3. 10-17-2008 01:39 PM #3
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline mod
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,842
    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
    Reply With Quote Reply With Quote
  4. 10-20-2008 08:59 AM #4
    snipes88
    snipes88 is offline Junior Member
    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width