PROCEDURE "ExportDatabaseObjectList" ()
BEGIN       
  -- List of tables
  EXECUTE IMMEDIATE 'EXPORT TABLE Information.Tables
     TO "TableList.txt"
     IN STORE Backups
     (Name)';

  -- List of views
  EXECUTE IMMEDIATE 'EXPORT TABLE Information.Views
     TO "Views.txt"
     IN STORE Backups
     (Name)';

  -- List of stored procedures
  EXECUTE IMMEDIATE 'EXPORT TABLE Information.Procedures
     TO "ProcedureList.txt"
     IN STORE Backups
     (Name)';

  -- List of functions
  EXECUTE IMMEDIATE 'EXPORT TABLE Information.Functions
     TO "FunctionList.txt"
     IN STORE Backups
     (Name)';

  -- List of roles
  EXECUTE IMMEDIATE 'EXPORT TABLE Configuration.Roles
     TO "RolesList.txt"
     IN STORE Backups
     (Name)';

  -- List of users
  EXECUTE IMMEDIATE 'EXPORT TABLE Configuration.Users
     TO "UserList.txt"
     IN STORE Backups
     (Name)';

  -- List of stores
  EXECUTE IMMEDIATE 'EXPORT TABLE Configuration.Tables
     TO "StoresList.txt"
     IN STORE Backups
     (Name)';

  -- List of jobs
  EXECUTE IMMEDIATE 'EXPORT TABLE Configuration.Jobs
     TO "JobsList.txt"
     IN STORE Backups
     (Name)';

END

---

 Comments

---

For now you have to execute the IMPORT TABLE and EXPORT TABLE administrative statements from the context of the database in which you wish to export the tables. For the script above, simply inserting a:

USE Configuration

statement before the EXPORT TABLE statements for the Configuration database will allow the statements to execute properly.

---

 Resolution

---

Scheduled for Future Release on 8/13/2009 in version 2.03 build 1

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial