If I have understood the scenario correctly, you have one installation of DBXL and want to use it as both Dev and Production.
To accomplish this, you’ll need two doctypes and two sets of tables. So let’s begin with the DEV tables. Let’s assume your DEV document type will map data to these three tables.
• DEVTable1
• DEVTable2
• DEVTable3
In the database tab for the DEV document type, you can control where the data gets shredded, simply select the specific tables (the DEV tables).
Once developed and tested, you want to create your “production” document type and tables. You can create tables with the same structure but remove the DEV prefix.
To create the production document type, click EDIT for the DEV document type. You’ll see a Save As button at the top. This will allow you to create a new document type, with the same XSN and database mapping, but with a different name.
Give the doctype a new name, and clik Save. This new doctype (“production”) will contain the same database mapping, though you’ll need to update the table names due to the removal of the DEV prefix in SQL.
You can control where the xml data is mapped by changing the data connection string. So you could have two document types, with the same xsn and the same mapping, but using two different connection strings. One will be dev/test and the other can be production.
Hopefully I’ve understood the question… let us know if you have any questions on this.