[Info-Ingres] Multi-database table references

[Jean-Pierre Zuate, La Fage Conseil]

Hello,

See anwers in your mail ...

Hope this help,
Regards,
-- 
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jean-pierre.zuate at lafageconseil.fr
http://lafageconseil.fr/

2007/9/24, Raghavan <rajiraghavan at gmail.com>:
>
> Hi,
>
> I have a legacy application running for more than15 yrs. Now I am
> wanting to use the concept of creating multi-databses for various
> reasons. The problem is,
> 1. I have to segregate the applications to various databases.
>     and assign tables pertainign to those databases.


You can achieve that with Ingres Star (see http://docs.ingres.com/star/toc).
Take car, all  SQL statements are not supported with Star (application
compatibility). See http://docs.ingres.com/star/SQLStatementSummary#o2097

2. In the current applciations as it is a single production database,
> i will have to introduce the concept of aliases for various tables to
> minimise the coding of the existing applications.


Aliases are synosyms. See http://docs.ingres.com/sqlref/CreateSynonym and
http://docs.ingres.com/sqlref/DropSynonym for details).

Has anyone handled such a scenario?

Personaly no, but i think too for one of my customer and I guess sometimes
it can give some way to workaround performance or high avaibility issues
(Start + Replication + multiple server node)


Can anyone help me?


Well, many of us can answer to questions (and sell to your company a perfect
service project to go straight forward with the result ;-)) but keep in mind
- has suggest Roy Hann in his reply - dealing with Star is "an other world",
due to some geographic contraint and housekeeping issues (just have a look
on unload/reload of a Star database ...), etc.

I hope you have :
- time
- environment for testing
- method and data to test

Last thing to say can be read the documentation and use vmware to test ...

;-)

Raghavan
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070924/c7e9ebb1/attachment.html