 |
 | 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 / January 2008Change schema for existing SDF
Created a SDF in VS2008. Saved it to VSS and saw that a field was misspelled. Welp used Server Explorer in VS2008 to connect to it but could not modify the schema field names at all. Then went into SQL 2005 and tried to connect to it and it said if it was CE 3 or later i'd need to run compact/repair on it to be able to open it. All the help points to programmatic manipulation. How do I best modify the field name for an SDF? TIA Harry In code you must drop the column and add a new one with the correct spelling. The "Data Port Console" from www.primeworks-mobile.com allows you to rename a field from the UI.  SignatureErik Ejlskov Jensen, Mobile App Dev MCTS Check out my SQL Compact blog at http://erikej.blogspot.com > Created a SDF in VS2008. Saved it to VSS and saw that a field was > misspelled. Welp used Server Explorer in VS2008 to connect to it but [quoted text clipped - 6 lines] > TIA > Harry |
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.