DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: help!toad schema comparison from prod to test

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    Exclamation

    i created a database link using toad from database1 to database2
    now i try to compare the schema difference using toad but dont know how to execute this has anyone done this before can you please give me a step by step guide
    from using toad to create the link to comparing the schema differences thanks so much!!!!!!

  2. #2
    Join Date
    Jan 2002
    Posts
    59
    you dont need dblink for this.
    all you need is the service names.
    make service names available for both dbs and you should get it.

    Thanx
    Sanjay

  3. #3
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    re

    so how would i do this? then?
    should i log into one database and then what next please help

  4. #4
    Join Date
    Jan 2002
    Posts
    59
    if you are using local names then
    edit tnsnames.ora file in your local system .
    make a copy of any existing service for a DB and do necessary changes.

    Thanx
    Sanjay

  5. #5
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    re

    my tns names is fine i can connect to both instances seperately on toad my question i how do i go about doing a comparison using TOAD?

  6. #6
    Join Date
    Jan 2002
    Posts
    59

    Thumbs up

    if you have full version of toad then make use of dba options and under that you would find compare schema....and every thing is click thru

    thanx
    sanjay

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