I have a database and some of the tables have fairly static business content. I would like to split the database into two with one for static business content and another for dynamic customer content. I have a dump and load utility I use for creating backups of the database. The static and dynamic tables and indices on the current database are currently under separate data areas.
1. Is there a recommended process for splitting/breaking a database into more than one?
2. Could I use the dump and load utility to split the databases by editting the schema.df and dbstrct.st files to create new versions for each database. Are there risks with using this method?
1. Is there a recommended process for splitting/breaking a database into more than one?
2. Could I use the dump and load utility to split the databases by editting the schema.df and dbstrct.st files to create new versions for each database. Are there risks with using this method?