User profile for richardjm

Just so you know I'm working on the options in Source Control however the main issue is actually creating storage options that are granular enough to be useful. The current single option has the subtlety of a sledgehammer. What individual settings would you think are necessary? So far my ideas run to... Ã¢â‚¬Å“Ignore TablespaceÃ¢â‚¬ / comments

Just so you know I'm working on the options in Source Control however the main issue is actually creating storage options that are granular enough to be useful. The current single option has the su...

0 votes

Creating users and roles is one level above what Schema Compare is designed to do. We can't create the target via the script. I was thinking about adding a UI for schema creation when creating the comparison but I'm not sure that's right either. I've just checked the nested type and it does appear in the Schema Compare interface. I've had a look into allowing options for comparison and it seems doable - there's even a file for it that isn't yet used (comparisonoptions.xml). It's on my list to look at as a potential quick-fix. Richard / comments

Creating users and roles is one level above what Schema Compare is designed to do. We can't create the target via the script. I was thinking about adding a UI for schema creation when creating the ...

0 votes

The Oracle team was pulled off in September last year to work on other tools and we're just starting to pick up the Oracle tools again to work on them. We're working on a roadmap, there's an offsite next week which may change things. Currently I'm testing a release that improves materialized view support (amongst a set of bug fixes) for Schema Compare and Source Control for Oracle (within the next few weeks I hope). I'm also finishing off a major update to Data Compare that should speed things up (parallel schema registration and a major improvement in timestamp comparison speed) Ã¢â‚¬â€œ there are still a few integration tests failing so it's not quite ready for final testing yet. If you want the pre-release version of Schema Compare and Source Control just let me know. / comments

The Oracle team was pulled off in September last year to work on other tools and we're just starting to pick up the Oracle tools again to work on them. We're working on a roadmap, there's an offsit...

0 votes

Of course I've just realised this topic is in Source Control - so disabling the "ignore storage" option isn't available (yet). / comments

Of course I've just realised this topic is in Source Control - so disabling the "ignore storage" option isn't available (yet).

0 votes

So for type support are you meaning nested tables? I've started playing with this recently and it seems to work in Schema Compare. My simple test case is.. create type acme.nt_nested is table of int; create table acme."RankTable" ( "ID" NUMBER(4,0) NOT NULL ENABLE, nest acme.nt_nested) nested table nest store as "RankTable_nt_tested"; For storage clauses there is an option "Ignore Storage" in Schema Compare that is enabled by default. Materialized views - as I've mentioned I've been working on a lot so now it supports complex queries, column aliases and grants. Indexes I'm not aware of anything outstanding. I'm still getting up to speed on Oracle so any help from experts about missing features is really appreciated (especially if they come with a simple reproduce case). Richard / comments

So for type support are you meaning nested tables? I've started playing with this recently and it seems to work in Schema Compare. My simple test case is.. create type acme.nt_nested is table of in...

0 votes

SQL Data Compare 5 is part of the bundle - you download the full bundle but just use the part you want. You can purchase and license SQL Data Compare 5 on it's own, also for this version we're introducing a slightly modified licensing so that you could purchase SQL Data Compare Pro - this includes both the full SQL Data Compare UI that people are raving about *and* the command line version. Hope this helps. / comments

SQL Data Compare 5 is part of the bundle - you download the full bundle but just use the part you want. You can purchase and license SQL Data Compare 5 on it's own, also for this version we're intr...

0 votes

Brilliant, thanks for that. [image] / comments

Brilliant, thanks for that.

0 votes

There was a bug in the beta code that falsely claimed there to be circular dependencies. This was to so with forwards and backwards references being stored for triggers. This meant any table with a trigger on it that referenced the triggered table counted as circular. Kudos to you for spotting it. Thanks / comments

There was a bug in the beta code that falsely claimed there to be circular dependencies. This was to so with forwards and backwards references being stored for triggers. This meant any table with a...

0 votes

A major part of the work for SQL Data Compare engine for version 5 was 'cleaning up' a lot of the API and integration with the SQL Compare engine for schema information. What this means is that applications that used the old API will need to be adapted to work with the version 5 API. Hopefully this should solve a lot of the complexities that existed in the previous API and make applications a lot quicker to develop. As you have noted one of the main changes is that TableComparisonSettings has been removed, this has been replaced with the Mappings classes. These give SQL Data Compare a lot of its power to compare databases with different schema information. Also of note is the new organisation of results stores - it used to be a set of up to 4 results stores per table difference these are now combined into one result store difference.ResultsStore you can still access the individual parts of the results store although I wouldn't recommend it. Here I include one of our example texts so you can see what is going on in the new API hopefully it will give you an idea of what to do... using RedGate.SQL.Shared; using RedGate.SQLCompare.Engine; using RedGate.SQLDataCompare.Engine; namespace Example { public class Example { public static void Main() { Database db1=new Database(); Database db2=new Database(); ComparisonSession session=new ComparisonSession(); TableMappings mappings = new TableMappings(); try { db1.RegisterForDataCompare(new ConnectionProperties(".", "WidgetDev")); db2.RegisterForDataCompare(new ConnectionProperties(".", "WidgetLive")); mappings.CreateMappings(db1.Tables, db2.Tables); // Create the mappings between the two databases session.CompareDatabases(db1, db2, mappings); foreach (TableMapping mapping in mappings) { if (mapping.Status == MappingStatus.Success) // Make sure that this is a valid mapping { ViewTableSuperClass table = mapping.Obj1; TableDifference difference=session.TableDifferences[table.FullyQualifiedName]; //display the different records using (Reader different=difference.ResultsStore.GetReader()) { foreach(Row row in difference.ResultsStore) //loop through all the rows { if (row.Type != Row.RowType.Same) //go through the non same records { Console.WriteLine("{0} Row {1} type {2}", table.FullyQualifiedName, row.Index, row.Type.ToString()); foreach (FieldPair field in different.Fields) { //work out where about in the results the field data is stored //if we were comparing identical records, or records present in one //database but not the other then we would not need to //use the OrdinalInResults1 and OrdinalInResults2 properties //but just OrdinalInResults int field1=field.OrdinalInResults1; int field2=field.OrdinalInResults2; if (field1 != field2) { //get the values object value1=row.Values[field1]; object value2=row.Values[field2]; if (value1 == null) value1="NULL"; if (value2 == null) value2="NULL"; Console.WriteLine("{0}\t{1}\t{2}\t{3}",field.Field(false).Name, value1.ToString(),Store.IdenticalValues(value1, value2, field)?"==":"<>", value2.ToString()); } else { //this is part of the unique index we are comparing on object value=row.Values[field1]; Console.WriteLine("*{0}\t{1}",field.Field(false).Name, value.ToString()); } }//End of foreach field pair } }//End of foreach row }//End of using reader }//End of mapping status }//End of foreach mapings } finally { //dispose of the object session.Dispose(); db1.Dispose(); db2.Dispose(); } } } } Note: There is also a new feature on the ResultsStore.Row object to determine if two fields on a row are different very quickly this is the FieldDifferent() method. Hope this helps initially. / comments

A major part of the work for SQL Data Compare engine for version 5 was 'cleaning up' a lot of the API and integration with the SQL Compare engine for schema information. What this means is that app...

0 votes

I've just had a quick look and Source Control for Oracle (SOCO) seems to support grants to roles and I'm not aware of any existing problems. Can you give an example or your issue - perhaps using support@red-gate.com / comments

I've just had a quick look and Source Control for Oracle (SOCO) seems to support grants to roles and I'm not aware of any existing problems. Can you give an example or your issue - perhaps using su...

0 votes

How can we help you today?

richardjm

Comments