We have a plan to use Microsoft SQL Server 2005 Compact Edition RC1 as a backend. Our Front-end is VS .NET (VB.NET).
We want to know how to edit the Compact Edition database (.SDF). Is there any editor is available right now in the market? or microsoft provided any editor for this.
OR Can i use microsoft 2005 sql server standard edition for this.
Thanks
You can find two desktop editors in my company's website. The first is based on .NET 1.1 and is now showing its age. If you want to take a look at the second, please be advised that although it has much more features, it is still a draft (but works). Comments and suggestions are welcome.|||You can edit the .sdf right in vs2005 or SQL 2005 Management|||I use SQL Server 2005 Management Studio to edit it.
But be weary, the functionality is very limited. For example, you can't add foreign key constraints, or editing an existing table, in many cases, requires you to rebuild the table... but there isn't a feature to export your table to a script.
I would highly suggest scripting the table instead of using the GUI.
|||Hi,
After a great struggle we have comeup with our own tool designed for managing the SQL compact edition database.
Here the url http://www.satwhiz.com/datapump/info.html . You can download the beta tool.
Please post your comments to gopalan@.sofist.com
Thanks
Gops
Sofist India
No comments:
Post a Comment