Opening a New DB-to-XML Data Source Document

To open a new DB to XML data source document, select File > New > DB to XML Data Source from the Stylus Studio menu.

Stylus Studio displays the DB-to-XML data source editor, and the Scenario Properties dialog box. You use the Scenario Properties dialog box to specify the database server connection settings.

Saving a DB-to-XML Data Source

DB-to-XML data sources are saved with a .rdbxml extension to their own file system, Relational DB.

Opening a DB-to-XML Data Source

You can open a DB-to-XML data source in one of two ways:

  • As a DB-to-XML data source, in the DB-to-XML data source editor. This gives you the opportunity to make changes to the data source as you originally defined it, including its connectivity settings and SQL/XML statements, for example.
  • As XML, using any Stylus Studio editor that accepts XML (such as the XML editor, for example). When you open a DB-to-XML data source as XM L, Stylus Studio displays only the XML that resulted from executing the SQL/XML defined on the SELECT tab.
To open a DB-to-XML data source:
1. Select File > Open from the menu bar.

Stylus Studio displays the Open dialog box.

Figure 313. Open Dialog Box

2. Click the Relational DB icon to display the files in the DB-to-XML file system.
3. Select the file you want to open.
4. If you want to open the file in the DB-to-XML data source editor, click Open.

To open the file in the XML editor:

a. Click the down arrow on the Open button.
b. Select XML Editor from the drop-down list.

Stylus Studio opens the file in the editor you selected.

Note

 

When you save a DB-to-XML data source that you have opened as XML, any SQL/XML statements you have defined on the UPDATE tab are executed.

SQL Server Tools

SQL Server Tools in Stylus Studio simplify working with relational and XML data including exporting data from a SQL Server database into XML and importing XML data back into SQL Server. Supports Microsoft SQL Server 2000 and Microsoft SQL Server 2005

Translating XML documents to X12

In-place, via XSLT and via XQuery are all mechanisms supported for converting XML to X12

Educational Institutions That Use Stylus Studio

Education is the most powerful tool one can have. That's why these top education providers reach for Stylus Studio to educate their students and professors as well. See which education providers have the most powerful XML IDE in their classrooms!

XML Programming

Simplify XML Programming with Stylus Studio's XML Pipeline, a powerful tool for modeling, programming, debugging and deploying complete XML programs.

Stylus Most Wanted

 
Free Stylus Studio XML Training:
W3C Member