MS SQL Server, symbolic link / virtual database

Shashank Dat
#1 / 4

symbolic link / virtual database

Is there any way to create "virtual databases" (or symbolic links) in SQL
2000 so that they show up as say DB_PROD1 in Enterprise Manager / Query
Analyzer (and have all the features of a database except storage) but
actualy point to a "real" database (say DB_OCT or DB_NOV with storage and
all) on the same server ?

Thanks,
-- shanko

Thu, 02 Jun 2005 01:02:11 GMT

oj
#2 / 4

symbolic link / virtual database

Not with sqlserver.

You *could* fake something like that by actually create a db and a whole
bunch of views that are pointing to another database. I wouldn't recommend
this, however.

--
-oj
http://www.rac4sql.net

Quote:

> Is there any way to create "virtual databases" (or symbolic links) in SQL
> 2000 so that they show up as say DB_PROD1 in Enterprise Manager / Query
> Analyzer (and have all the features of a database except storage) but
> actualy point to a "real" database (say DB_OCT or DB_NOV with storage and
> all) on the same server ?

> Thanks,
> -- shanko

Thu, 02 Jun 2005 03:56:07 GMT

David Penne
#3 / 4

symbolic link / virtual database

Shashank,

you can do exactly this using the MetaMatrix Server.

Please leave a message on our website describing your project and contact
details - mention my name if you want to know more & the message will bypass
the sales group & come straight to me.

Regards,
David Penney
CTO - Europe
http://www.metamatrix.com

Quote:

> Is there any way to create "virtual databases" (or symbolic links) in SQL
> 2000 so that they show up as say DB_PROD1 in Enterprise Manager / Query
> Analyzer (and have all the features of a database except storage) but
> actualy point to a "real" database (say DB_OCT or DB_NOV with storage and
> all) on the same server ?

> Thanks,
> -- shanko

Thu, 02 Jun 2005 05:55:50 GMT

David Penne
#4 / 4

symbolic link / virtual database

you can do exactly this using www.metamatrix.com - its a virtual database.

leave a message describing more of your project & contact details on our
website - mention my name if you want to know more & it will bypass the
sales group & come straight to me.

Regards,
David Penney
CTO - Europe
MetaMatrix

Quote:

> Is there any way to create "virtual databases" (or symbolic links) in SQL
> 2000 so that they show up as say DB_PROD1 in Enterprise Manager / Query
> Analyzer (and have all the features of a database except storage) but
> actualy point to a "real" database (say DB_OCT or DB_NOV with storage and
> all) on the same server ?

> Thanks,
> -- shanko

Thu, 02 Jun 2005 05:55:49 GMT