Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-17 : 10:17:57
|
| Adam writes "Along with a transition from SQL Server 6.5 (WinNT) to SQL Server 2000 (WinNT now, W2K soon), we would like to rename some of our databases to use a better naming convention. (From something like grpdbnrr01d to the easier to remember projname_d.)To try to reduce the headaches with the effort to update all our systems that reference the database name, we'd like to see if there is a way to rename our database to the new name, but provide an alias with the old name so that things we might have overlooked don't automatically break.If we can find an alias, we can update the database name at the same time we transition servers. If not, we'll just have to wait a while (post server transition) and organize the update effort in detail.Thanks for any help." |
|
|
|
|
|
Create a database name alias to ease transition