Geek Answers Handbook

SQL Server Compact - Schema Management

I was looking for some time for a good solution to implement the idea of ​​schema management in a SQL Server Compact 3.5 database .

I know several ways to manage the schema on SQL Server Express , SQL Server Standard, SQL Server Enterprise, but the Compact Edition does not work, t support the necessary tools needed to use the same methodology.

Any suggestions / tips?

I have to expand this to say that this is for 100+ clients with wrapper software. As the system changes, I need to publish update scripts along with new binaries for the client. I was looking for a decent way to post this without having to just pass the script file to the client and say “Run this in SSMSE”. Most customers are not able to make such a beast.

A friend of mine opened a partial script on how to handle part of my SQL Server task, but never worked on Compact Edition. Looks like I'll be on my own.

What I think I’ve decided to do and will need a “playing week” for him is to write some kind of tool similar to the WiX and NAnt way , so I can just write an overdone XML document to handle the work.

If I think this is appropriate, I will post it on CodePlex and / or the Draft Code , because I used both sites a bit to better understand the concepts for workplaces that I have done in the past, and I think it is probably worth it discard a little.

Change on 5/3/2010:

- "" , / , MS SQL, CodePlex, , , SQL Compact. , , , , SQL Compact XML , Installable Silverlight. Silverlight .

+5
4

Migrator.Net. , , #.
, / , .

, , , - , . . , :

Assembly asm = Assembly.Load("LocalModels.migration");
Migrator m = new Migrator("SqlServerCe", "Data Source=LocalModels.sdf", asm, false);
m.MigrateToLastVersion();

Compact (, - dbo). , .

+2

( , )

  • Microsoft Sync Framework . , , (, , ). MSDN

  • , - SQL Management Studio, / T-SQL, , T-SQL ( , CE), , "" , Sync Framework .

0

, , , - (, - , CMS), , . , , , , .

0

SQL Server Management Studio ?
http://technet.microsoft.com/en-us/library/ms172933.aspx

-2

More articles:


All Articles