开发者

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

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

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

精彩评论

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