I've moved database from one SQL Server instance on a machine to another machine completely. 开发者_如何学运维 Is there any way to forward requests to the new server automatically so it doesn't require client config changes? Keep in mind it's only one DB out of many on the original server so I can't just forward all requests.
You could define an alias for your new server that is the name of the old server/instance - but that would forward all requests to the new server.
As far as I know, SQL Server doesn't have a concept of a "database alias" as of yet.
See this discussion thread on MSDN social about this topic.
精彩评论