 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / May 2007Problems with Exporting From SQL Server 2005 Enterprise
I'm trying to do something that I thought would be relatively straightforward. I have a SQL Server 2005 (Enterprise) database that I'm trying to turn into a SQL Server CE database. My database has about 20 tables and about 100 data rows among those tables so I would rather not have to recreate manually. I tried using SQL Server Manager to generate the scripts and then just run them as queries against the CE database. Sadly, I can only do one at a time because apparently CE doesn't accept batches. I could do each insert one at a time, but that isn't much better than entering this stuff manually given the amount of data that has to be entered. It seems like everything I try fails for one reason or another and I just can't believe that there's no easy way to do this . Any ideas? In my EBook I include a batch utility class (similar in function to SQLCMD) that I used to populate the schema of SQLCe databases. It seems to work fine. I hope it can help.  Signature____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ----------------------------------------------------------------------------------------------------------------------- > I'm trying to do something that I thought would be relatively > straightforward. I have a SQL Server 2005 (Enterprise) database that [quoted text clipped - 9 lines] > It seems like everything I try fails for one reason or another and I > just can't believe that there's no easy way to do this . Any ideas? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.