开发者

Can I upgrade SQL Server express to Standard version on different machine

If I have a new install of SQL Server Standard on one machine, can I easily import my database from SQL Server Express on another machine? I was planning to detach the db transfer the file and attach on new machine. Is this the easiest way? What about permissions? Will this work?开发者_StackOverflow中文版


Yes, that approach will work. For more information on the security ramifications, please see the MSDN article "Securing Data and Log Files". There's also a good knowledgebase article on How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server (see the section on "Moving user databases").

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜