Clever Geek Handbook

How to migrate or migrate SQL Server 2008 Compact Edition to Express Edition

I have created a database in SQL Server 2008 Compact Edition and now I want to migrate this database to SQL Server 2008 Express Edition.

How can I achieve this? Please suggest steps to me. As it is now, this is my project requirement.

+2


source to share


1 answer


Moving from Compact to Express Edition should be as easy as scripting database structures and objects and re-creating them in a SQL Express Edition instance. It should be straight forward, as Express supports more code than Compact. Most people run into problems stemming from Express to Compact and not the other way around, because the Compact Edition has a limited coding model.



In SSMS 2008, you also have the Script Data option under Table / View Options in the Script Wizard, so you can easily migrate data using the built-in Script Wizard in SSMS 2008. To open the Script Wizard, right-click on the Tasks database → Generate scripts.

+2


source






More articles:


All Articles