On 03/17/11 18:29, Woody wrote: > 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? If you have DatabaseAccess = Restrict /some/path in firebird.conf, each connection to server:database.fdb (when database.fdb is not found in aliases.conf) will expand to server:/some/path/database.fdb.
What about exactly what you want - worth thinking on my mind. ------------------------------------------------------------------------------ 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
