Just curious, has there been any discussion about expanding aliases to allow 
defining just a path to a directory where multiple database reside?

The reason I'm asking is that in some situations, my apps are designed to allow 
the users to archive fiscal data. In general, they have a main database for 
active information and an archive database for current archive data. Each 
fiscal year, the information in the current archive database is copied to a new 
fiscal archive database and then cleared for the new fiscal year. That means 
that there could be years of data in individual databases but they all reside 
in the same directory.

Currently, to use aliases, I would have to add an alias each time a new DB is 
created. If there were a way to specify an alias for a particular directory, I 
could use that to build a complete database name something like:

    servername:aliasname:databasename 

That would allow more dynamic building of connection strings. At the moment, I 
usually store the database path in each users settings file and just tack on 
the database name as I need it. However, if the location changes, each users 
settings would have to be changed. It would be nice if I could declare an alias 
in the alias.conf file to use as a base directory.

Any thoughts?

Woody (TMW)
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to