Embedded Files
Synonyms
Synonyms
The sys.create_synoymn_db procedures makes it really easy to create a new database containing only VIEWs referencing all TABLEs in you source schema....
CALL sys.create_synonym_db('mysourcedb','mytargetdb');
+-----------------------------------------------+
| summary |
+-----------------------------------------------+
| Created 12 views in the `mytargetdb` database |
+-----------------------------------------------+
1 row in set (0.2475 sec)
Query OK, 0 rows affected (0.2475 sec)
Bibliography
Bibliography
Page updated
Google Sites
Report abuse