|
Hello,
I've an Oracle database with two schemas. One is old and another is new. I would like to update the old schema with the new columns of the new schema.
I get the tables which have changes with the following query.
select distinct table_name from...
Started by coder247 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You should go for a schema be to download Oracle's SQL Developer and use....
As long of caveats became longer than the answer so I decided to scrap it .
I've found is to extract the schema definitions to text, then run a text compare.
|
|
I got one problem from comparing database schema as i use Red gate SQL Compare 6 , after initialization of the compare databases error is coming as following
"Index was outside the bounds of the array".
Please provide your valuable comments to get resolve...
Started by Paresh on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The computer running SQL Compare is using.
Or 7 , it appears.
Version 6 on 64 bit versions of SQL Server...
|
|
I am looking for a tool that will allow me to compare schemas of MySQL databases.
Wich is the best tool to do that?
Started by Shvilam on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
I've used it with success to the party....
It will also synchronize schema and/or data between two mysql database instances.
To compare MySQL database schemas
It exports the schema and serialises it before doing the comparison.
|
Ask your Facebook Friends
|
I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?
Started by tomaszs on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
The Schema Compare and Migration Tools to compare testing and deployed databases, migrate existingI am using Red-Gate's software: http://www.red-gate.com
I use schema and data comparison the schemas plus data to plain....
|
|
I have 2 schemas in a database about the same application (Different versions)
I want to generate a Delta script with the differences
It exists some tool that helps me (Open source solution should be perfect)
Thank you
Started by xfernandez on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It will compare tables showing you all the differences and also provide you with the SQL-diff does schema comparison....
Http://sourceforge.net/projects/schema-compare/
basic but working
mysql (US$179).
Linux, and Mac versions.
|
|
I'm looking for a way to validate the SQL schema on a production DB after updating an application version. If the application does not match the DB schema version, there should be a way to warn the user and list the changes needed.
Is there a tool or ...
Started by Ron Harlev on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
However, there....
If you are looking for a tool that can compare two databases and show you the difference Red Gate makes SQL Compare
You can do and comparing them.
SQL Compare by Red Gate .
Setup or wherever is convenient.
|
|
Hi,
Can some body please, give me idea on how can I do a schema compare between the build script in TFS and the database in the server for that build.
Thanks
Answer Snippets (Read the full thread at stackoverflow):
Clunky, but it works :-).
Script out the prod DB and compare the scripts with a diff tool.
Generally speaking, you cannot reliably compare DB schemas: for instance, renames will never, to a text file.
|
|
I want to backup the schema of a sql server 2005 database from the command line. Whats the best way to do this?
Update
I ended up buying SQL Compare 8.1 from Red Gate Software.
It works just as well as Change Director and is 1500 dollars cheaper.
Started by Justin Tanner on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
The schema specifically, and not the data? Why are you backing up....
There isn't a single command to script out just the schema.
This will backup the schema and the data.
Use the BACKUP DATABASE command to backup the entire database .
|
|
Does anyone know any software to synchronize or compare Oracle schema? For e.g. SQL Compare of Red Gate is used to compare two schemata of SQL Server database.
Moreover, could you tell me how to put the code of Oracle stored procedures, stored functions...
Started by Sambath on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The new product will be named Schema Compare for Oracle/schema_compare_for_oracle/index.htm
David....
Sybase's PowerDesigner tool to the Oracle platform.
A pretty thorough and easy to use schema compare/synchronize.
|
|
Are there techniques for comparing the same data stored in different schemas? The situation is something like this. If I have a db with schema A and it stores data for a feature in say, 5 tables. Schema A -> Schema B is done during an upgrade process...
Started by vholstein on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The difficult part may be to obtain object representations is, in principle, capable of... .
Basically, you should create object representations for both schema versions, and then compare, compare them, and then do the same vice versa.
|
