Yes, the SQL to XML functionality sits above Virtuoso's virtual database functionality, which enables a unified logical and physical representation of database tables and views that reside in disparate database engines from different database vendors. The only requirement is that these database have to be ODBC or JDBC accessible - implying the existence of data access drivers for these databases.

Yes, Virtuoso implements SQL extensions that enable the results of standard SQL queries to be transformed into XML documents, these documents are openly accessible to user agents such as Web Browsers via HTTP and/or WebDAV. It is important to note that these SQL-XML documents are URL accessible, and sensitive to the underlying changes that occur in the underlying database tables from which they have been derived.

A lot of data that you would typically like to use as the foundation of your web application initiatives more than likely resides in application databases that are predominantly SQL based.

SQL Data Compare works out which columns are common between the two databases and compares the contents of those columns. If the two databases are radically different (e.g. if the primary keys are different, or if column data types are different) then it probably won't work. If this is the case, you can use SQL Compare to synchronize the structure of your databases and then use SQL Data Compare to compare the contents.

CNRI uses Berkeley DB for its major handle installations. The current handle server version includes code that helps you connect the Berkeley DB to your handle server instance. See the Technical Manual, Chapter 12, Enabling Berkeley DB JE Database Support, for information. Support for other databases is possible for anyone who provides a Java class, implementing the net.handle.hdllib.HandleStorage interface, to store and retrieve handles.

Using the DTS ActiveX Script Task it is pretty easy to accomplish something like this. Here is a script that I used to create a Package which was scheduled and executed successfully. '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Dim oCmd, sSQL, oDom ''' If MSXML 4.0 is not installed this will not work! Set oDom = CreateObject("Msxml2.DOMDocument.4.

Yes, you can. One way to do this is to first build a JDOM tree from your XML document, and afterwards expose JDOM tree nodes as data models. The FreeMarker-Ext library has a class that can wrap JDOM nodes to expose them to FM-Classic as a template model. In order to wrap your JDOM document tree in a FM-Classic TemplateModel, it is sufficient to do the following: ... org.jdom.Document document = getMyDocumentSomehow(...); TemplateModel model = new freemarker.ext.jdom.NodeListModel(document); ..

There is a whole world of applications where an XML database is the best solution. For these applications an XML database will often far surpass a relational database in convenience, ease of development and performance. Applications where XML databases are often used consist of corporate information portals, membership databases, product catalogs, parts databases, patient information tracking, business to business document exchange as well as many many others.

Yes. SQL Data Compare has been designed to work with the very largest commercial databases (e.g. SAP in Fortune 100 companies). For example, we've successfully tested the SQL Bundle on databases 100s GB in size, with 150,000+ database objects.

The only limitations on the amount of data you can actually compare are dictated by the amount of disk space available to SQL Data Compare. Yes; it works on all data types and all tables. If you are having a problem, please make sure you are using the latest version of SQL Data Compare, as the latest version is even more versatile than the previous version.

PSLF software can import dynamic data in WSCC and PTI formats. WSCC data is imported using rdws. Under the small menu, rdws is in the PSDS panel. Using the large menu, it is under dsix.

Yes, a small amount of custom automation is required to extract and interpret your custom data source, but the process of asking the Apprentice to drop and arrange the shapes based on rules is inherent in our products.

Q: Why can't GnuCash find my data file anymore? It just says: parser error : Start tag expected, '<' not found

Include EXPLAIN command in the embedded dynamic SQL statements 52.How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)

It doesn’t matter where the data is held, as long as it is accessible from your computer, ie, networked. LinkUP follows paths that are set up by you to connect to your data.

Depositit can backup SQL files, and information on how to do this can be found by downloading our white paper from: < here >.

Yes. We support the use of SQL, MySQL and Access databases and allow the creation of unlimited system DSN's through our customer Control Panel ther is an extra charge per database and user. We also support the following driver types on NT servers: Excel, DBase, Paradox, Text and Visual FoxPro. You should only use Access 2000 or higher databases. If you use Access 97 you may receive the following error: Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.

Yes we do!!. Developers on our servers use PHP and MySQL to develop interactive sites - we do support these.

SQL Data Compare will use much less disk space if you limit the kinds of records that are compared. For instance, if you choose to compare only the different records and omit the missing and additional records, the temporary files that SQL Data Compare creates on the client will be much smaller.