Home » RDBMS Server » Server Administration » Schema difference Script (merged 3)
Schema difference Script (merged 3) [message #352262] Mon, 06 October 2008 22:27 Go to next message
niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore
Junior Member
Hi guys,


I want to compare schema test and test1. need to compare both and apply all the changes to test. let me know if there is ant script or tool is avaiable.


Thanks
Nitesh
Re: Schema diffrence Script [message #352266 is a reply to message #352262] Mon, 06 October 2008 22:35 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Which tool you are using for debugging ?
It is available in almost all 3rd party tools .

Thumbs Up
Rajuvan.
Re: Schema diffrence Script [message #352267 is a reply to message #352266] Mon, 06 October 2008 22:40 Go to previous messageGo to next message
niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore
Junior Member
toad can give the diffrence script between both the schema, but I want the same in linux plateform using some command line utility or Script as I need to automate this task. So Please help me out in this

Thanks
Nitesh
Re: Schema diffrence Script [message #352278 is a reply to message #352262] Mon, 06 October 2008 23:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Compare what? Table list? Table structure? Object? Data? Storage?...

Regards
Michel
Re: Required Schema Diffrence Script [message #352280 is a reply to message #352262] Mon, 06 October 2008 23:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost your question.

Regards
Michel
Re: Schema difference Script (merged 3) [message #352434 is a reply to message #352262] Tue, 07 October 2008 11:10 Go to previous messageGo to next message
niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore
Junior Member
Hi,

Basically I want to comapre all the objects in schema including table structure bot not data.


Thanks
Nitesh
Re: Schema difference Script (merged 3) [message #352493 is a reply to message #352434] Wed, 08 October 2008 01:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to do it in SQL script, query dba_tables and db_tab_columns.

Regards
Michel
Re: Schema difference Script (merged 3) [message #352518 is a reply to message #352493] Wed, 08 October 2008 02:45 Go to previous messageGo to next message
niteshnandawat
Messages: 4
Registered: October 2008
Location: bangalore
Junior Member
Hmm,


But dear I need a shell script which can find out the diffrence and can genrate a sql script.

Thanks
Nitesh
Re: Schema difference Script (merged 3) [message #352521 is a reply to message #352518] Wed, 08 October 2008 02:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post you already did.
You don't expect we will do all the work for you, don't you?

Regards
Michel
Re: Schema difference Script (merged 3) [message #352535 is a reply to message #352262] Wed, 08 October 2008 05:04 Go to previous messageGo to next message
mengxb001
Messages: 4
Registered: December 2007
Location: China
Junior Member
you can use toad to compare the schema difference.
Re: Schema difference Script (merged 3) [message #352536 is a reply to message #352535] Wed, 08 October 2008 05:10 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read all the answers BEFORE posting. It is useless to repeat an answer that was rejected.

Regards
Michel
Previous Topic: Resize datafile
Next Topic: How to read statspack results
Goto Forum:
  


Current Time: Fri Dec 09 19:11:26 CST 2016

Total time taken to generate the page: 0.14253 seconds