SQL Server CE deploying schema changes to the client .sdf file

167 Views Asked by At

I have never used SQL Server CE before, but I have a small project which would benefit from CE instead of full-blown SQL Server.

Within Visual Studio I can create the DB schema which then generates an SDF file. I'm assuming that schema and data both go in here.

Now let's say it contains just 1 simple table:

Customer
========
ID int PK
FirstName varchar(50)
Surname varchar(50)

I build a C# Win Forms application and then send it to the client. They use it for a bit to record customers, and then say they would like to include a Mobile number. I then alter the table as follows:

Customer
========
ID int PK
FirstName varchar(50)
Surname varchar(50)
MobileNo varchar(50)

I alter the C# Win Forms application to be aware of the new field, but now when I send the software to the client, how can I update their database?

I want all existing data within the client's .sdf file to be exactly as it was, but I want to alter the schema of it to include the new MobileNo field.

Is there some kind of schema deployment built into the SQL Server CE libraries?

0

There are 0 best solutions below