开发者

Forward DB requests after a DB move in SQL Server

开发者 https://www.devze.com 2022-12-28 04:33 出处:网络
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 requ

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号