SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 07:41 AM
| ||||
| ||||
 For Schema Comparision Experts Hi There, I have a task that needs me to compare two different schemas in two different databases. My issue is with connectivity. How do I use the information about the second database (ie the database Im not using currently). Your suggestions are most welcome. Thanking you in anticipation. Regards, Amit      |
|
02-25-2008, 07:41 AM
| |||
| |||
| Re: For Schema Comparision Experts > I have a task that needs me to compare two different schemas in two > different databases. > > My issue is with connectivity. How do I use the information about the > second database (ie the database Im not using currently). I'm sure you can resolve this using PL/SQL and database links but for ease of use I use a tool called PL/SQL Developer to compare schemas in different databases. It connects to both databases and generates SQL between target and source that can be applied to the target to get it in sync with the source. Note: this only applies to data structures and not data, although PL/SQL developer also has a data sync tool too. |
|
02-25-2008, 07:41 AM
| |||
| |||
| Re: For Schema Comparision Experts What version of Oracle are you on? It might be useful for you to consider the Enterprise Manager Change Management grid functionality. This might save you starting from scratch and building all over again the same thing provided already. It will also save you picking up a third party tool. oracledba.amit@gmail.com wrote: > Hi There, > > I have a task that needs me to compare two different schemas in two > different databases. > > My issue is with connectivity. How do I use the information about the > second database (ie the database Im not using currently). > > Your suggestions are most welcome. > > Thanking you in anticipation. > > Regards, > Amit |
|
02-25-2008, 07:41 AM
| ||||
| ||||
| Re: For Schema Comparision Experts Amit, The free, open-source SchemaCrawler tool will compare the schema and data. SchemaCrawler outputs details of your schema (tables, views, procedures, and more) in a diff-able plain-text format (text, CSV, or XHTML). SchemaCrawler can also output data (including CLOBs and BLOBs) in the same plain-text formats. You can use a standard diff program to diff the current output with a reference version of the output. SchemaCrawler can be run either from the command line, or as an ant task. A lot of examples are available with the download to help you get started. SchemaCrawler is free, open-source, cross-platform (operating system and database) tool, written in Java, that is available at SourceForge: http://schemacrawler.sourceforge.net/ You will need to provide a JDBC driver for your database. No other third-party libraries are required. Sualeh Fatehi. oracledba.amit@gmail.com wrote: > Hi There, > > I have a task that needs me to compare two different schemas in two > different databases. > > My issue is with connectivity. How do I use the information about the > second database (ie the database Im not using currently). > > Your suggestions are most welcome. > > Thanking you in anticipation. > > Regards, > Amit |
Linear Mode
