jamescompton123
MIS
Hi,
I'm currently working on updating/re-writing some Impromptu catalogues to work against a new database. Whilst most of the tables and structures are new and will need to be completely redone there are some snapshotted tables from another database that will remain the same. Is it possible to in some way combine/add a schema into an existing one?
For example, I currently have
Schema A, containing tables
1, 2, 3
and
Schema B, containing tables
4, 5, 6
I have repointed the catalogue to look at the new database and both schema A and B still exist, but schema A no longer contains tables 1, 2, 3 and I would like to be able to add those tables to Schema B without having to bring them in again and losing all the underlying Joins and calculations based on those tables. Any ideas?
Many Thanks,
James
I'm currently working on updating/re-writing some Impromptu catalogues to work against a new database. Whilst most of the tables and structures are new and will need to be completely redone there are some snapshotted tables from another database that will remain the same. Is it possible to in some way combine/add a schema into an existing one?
For example, I currently have
Schema A, containing tables
1, 2, 3
and
Schema B, containing tables
4, 5, 6
I have repointed the catalogue to look at the new database and both schema A and B still exist, but schema A no longer contains tables 1, 2, 3 and I would like to be able to add those tables to Schema B without having to bring them in again and losing all the underlying Joins and calculations based on those tables. Any ideas?
Many Thanks,
James