May 22, 2007 at 6:34 am
Hello
I am not an experienced SQL Server user and I am struggling with transferring tables and data from SQL Express to SQL CE. So far I've succeeded in using Management Studio Express to create a script to export the structure of a table from Express. I've also succeeded in modifying the script so that I can run it and create the new table in CE. I had to modify the Constraints a lot. I hope the limitations of CE don't make my DB useless in CE. Anyway, the bigger problem at the moment is how do I get the data?
Should I try replication? Replication seems to require a web server, which I do not have. I have my SQL Express files and my SQL CE files on the same desktop.
I hope someone can give me some help. Thank you in advance.
Clark
October 22, 2007 at 1:09 pm
Please see my response here:
http://www.sqlservercentral.com/Forums/Topic376763-323-1.aspx
This is a very popular problem for Express and Developers versions.
May 21, 2008 at 7:01 am
I found this wonderful program on the CodeProject site that solves this problem and works quite well to copy tables from SQL Server 2005 Express to a SQL Server Compact Edition Database:
http://www.codeproject.com/KB/database/SqlCompactCoptUtility.aspx?display=Print
Beware that when you compile it, there will be a warning that it cannot find some files. Just acknowledge and let it continue and the program will work. I haven't found the time to troubleshoot the missing files yet so, if someone else does, please let us know here. I just know that it worked "as-is" to copy my Express DB to Compact DB.
Incidently, Code Project is another great developer resource just as SQLServerCentral is. I have found that by using both of these sites, I can find solutions to most of my development questions; whether SQL Server or general programming related. 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply