XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
mork afurSubject: How to DIFF XML windows with database->XML imported data???
Author: mork afur
Date: 20 Mar 2008 04:12 PM
I've opened two XML windows in SS where I've used one connection to import one DB table data from one Oracle Schema and another connection to import one DB Table data from another Oracle schema. So far so good.

However, no matter what I do, I can't seem to "diff" these two windows.

It seems that SS wants disk files or folders only for DIFFing.

I opened each of the two windows using the Open..With...XML Diff.

However, this action just opened up two windows (one with each imported DB->XML data).

How can I actually DIFF imported two DB tables?

I have SS Enterprise.

Thanks in advance.

M

Postnext
Alberto MassariSubject: How to DIFF XML windows with database->XML imported data???
Author: Alberto Massari
Date: 26 Mar 2008 12:23 PM
Hi,
in order to diff two database tables you should open both tables inside Stylus Studio (e.g. by doing a drag & drop of the tables from the File Explorer), then open a new XMLDiff window (Tools | Show Differences in ... Files), then typing in the two edit boxes the full paths that you can see in the tooltip that appears when hovering over the tab of the document (e.g. xquery:///jdbc:xquery:sqlserver://dbserver:1433;schema=dbo;table=Authors;user=sa;xmlforest=true;DatabaseName=Books;urltype=.xml)

Hope this helps,
Alberto

Posttop
O BarrettSubject: How to DIFF XML windows with database->XML imported data???
Author: O Barrett
Date: 26 Mar 2008 03:16 PM
I tried this but got a "String out of range: 7" or some type of cryptic (non-helpful) message like that.

I also tried to drag and drop a larger table and got a Java Heap Space Error.

Seems there are some usability issues here as well as outright bugs.

Diffing database tables should work like everything else and have enough memory (or a field selector to remove larger fields like CLOBS).

Thanks much for your reply...I guess the easiest way to DIFF DB tables is to write the XML representation to disk and then use the built-in Stylus Studio DIFF tools that seem to want physical XML files.

Thanks again!!!

-- M

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.