Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.02 » View Incident Report |
Minor |
Reported By: Steve Gill Reported On: 8/11/2009 For: Version 2.02 Build 15 |
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
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |