开发者

how to convert an SQL server 2005 .mdf to SQL server CE .sdf?

开发者 https://www.devze.com 2023-01-17 22:04 出处：网络

HI , I created a project where it can work with SQL server 2005. Now i want this project to be migrated to SQL server CE 3.5 which will run inlow config system ( XP , 500 MHZ and RAM 488) How do i c

相关专题：sql sql-server sql-server-2005

HI ,

I created a project where it can work with SQL server 2005. Now i want this project to be migrated to SQL server CE 3.5 which will run in low config system ( XP , 500 MHZ and RAM 488) How do i convert my .mdf to .sdf 开发者_如何学运维 .I used third part tool lik e PrimeWork but when i am trying to load it says not compatible . any help ?

Try this: http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/fd3b14c5-5474-4ad9-b373-b6385881780f/

Also, I haven't tested this, but it seems to get the job done: http://www.codeproject.com/KB/database/SqlCompactCoptUtility.aspx

MAKE BACKUPS BEFORE YOU DO ANYTHING! :)