Hi to all,
I would like to develop an app for both Intersystem's Cache as well as MS SQL Server databases. Cache manages the concept of Namespaces which groups a number of tables, so, once I have my cache-ds.xml defined in /deploy I can access the tables nameSpace1.Table1, nameSpace1.Table2, but it also allows me to use nameSpace2.table1, all with just one datasource.
The question is: is there anything similar in MS SQL? Can I, with one datasource, access different databases in my SQL service? Is there somewhere the concept of namespaces or something similar? Can I connect to 'master' and create for example a table in a different database?
Regards
Alejandro