Restore of SQL Personal Edition DB onto SQL Standard

Are there any issues with restoring a normal DB backup from a machine running
SQL Personal Edition onto a Standard Edition machine, and will the restored
DB have the scalability of any other Standard Edition DB?
Thanks,
Mike Bell.
No issues. Scalability will not be affected. All editions use the same
on-disk file structures so the databases are interchangable.
Geoff N. Hiten
Microsoft SQL Server MVP
"mjhbell" <mjhbell@.discussions.microsoft.com> wrote in message
news:FD211F6E-98E5-4728-AB7D-EF0665316F5C@.microsoft.com...
> Are there any issues with restoring a normal DB backup from a machine
> running
> SQL Personal Edition onto a Standard Edition machine, and will the
> restored
> DB have the scalability of any other Standard Edition DB?
> Thanks,
> Mike Bell.
|||The scalability is not built into the database itself. You will be fine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mjhbell" <mjhbell@.discussions.microsoft.com> wrote in message
news:FD211F6E-98E5-4728-AB7D-EF0665316F5C@.microsoft.com...
> Are there any issues with restoring a normal DB backup from a machine running
> SQL Personal Edition onto a Standard Edition machine, and will the restored
> DB have the scalability of any other Standard Edition DB?
> Thanks,
> Mike Bell.