Geek Answers Handbook

Should I include my SDF file (SQL CE 3.5) as an element when adding a solution to the original control?

I have a Visual Studio 2010 solution that uses SQL CE Fiel (SDF) to store data in one of the projects. I am wondering if it is useful to add this SDF file to the original control so that whenever I make any changes to the database, I pass it to the original control?

Sometimes all I do is change the name, for example, I have to transfer the 1 MB file to the original control. Does it make sense?

What do you worry about this?

+4
source share
1 answer

If you cannot create / run a project, choosing a new release due to the lack of a file, you need to add it to the original control.

Yes, this is a binary file, and you cannot distinguish it, but as the column names change over time, your code must change to work with this scheme. It makes sense to store everything in the original control, since they must match.

If you really can not pass it to the source control in the form of binary code, then consider writing it when creating an application for the database at startup, if there is no db. The following tool will interact in the sql management studio to include scripts.

http://exportsqlce.codeplex.com/

+3
source

More articles:


All Articles