database alias

[sixteamparlay]

Is it possible to give a database an alias name?

we have a database called Database

after a software migration the database had to be copied to Database2

There is no way in the software package to change what db it points to once it is installed.

Is there a way I can create an alias so Database points to Database2?

Thank you

 

[sixteamparlay]

I forgot to mention we run SQL Server 2005

 

[gmmastros]

Can you simply rename it back to Database ?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[sixteamparlay]

Yes that is easy in SQL 2005 management studio but the s/w doesnt allow us to change where it points to. Is there a way to alias?

 

[bborissov]

This is an alias [DATABASE2]. If you see the actual names of the DB it could be something like:
MyDBThatIsHere.mdf
So rename it with SSMS.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[gmmastros]

Is there a way I can create an alias so Database points to Database2?

No. Not that I am aware of.

There are a couple things you could do. If your application is looking for a database named [Database], then that database must exist. So, renaming the database is certainly an option.

If you can't rename the database, then perhaps you could create a new database named [Database] and then use synonyms to point to [Database2].

Ex:

Create Database [Database]
go
Use [Database]
go
Create Synonym [dbo].[YourTableNameHere] For [Database2].[dbo].[YourTableNameHere]

Unfortunately, you will need to create synonyms for EVERY object in your database (Tables, views, procedures, functions, etc...)

You'll also need to remember to create synonyms anytime you add an object. This will NOT be fun.

Synonym is new functionality introduced in SQL2005. (So you SQL2000 users should ignore this.)

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom