SQL Server CE .sdf merge
My application is running on Windows CE 6.0, and it uses a SQL Server CE .sdf file to store user data. The application is running on an industrial device, which is not connected to internet. The only way to update the software is to plug a USB stick inside.
As expected, the first release 1.0 of the application needs to update to 1.1 now, the database schema as well.
How could I merge the .sdf version 1.0 which is on the device with the latest 1.1 database schema that will be available through the File System (USB stick) of the device.
I added a picture below to help understanding my question.
I am aware about RDA and Merge Replication possibility, but my application is not connecting to a central server through http. Before learning how to use them I would like an expert advice.
You will need to programatically apply the changes required for the schema to change from 1.0 to 1.1. You can do this by using ALTER TABLE/CREATE TABLE statements, combined with inspecting the current schema by querying the INFORMATION_SCHEMA views
- Why can't I use an alias in a DELETE statement?
- SQL Server Compact error: Unable to load DLL 'sqlceme35.dll'. The specified module could not be found
- Reverse boolean (bit) value in SQL CE select statement
- Need INFORMATION_SCHEMA MetaData
- UpdateException when using SQL Server Compact with Entity Framework
- The selected object(s) use an unsupported database provider
- How to decipher/interpret the contents of a file as shown in a Hex editor?
- Cannot find namespace 'System.Data.SqlServerCe'
- Linq dbml interchangeable between SQL Editions
- What to select in catalog in platform builder to include SQL CE in image for windows CE
- How to use Scaffold-DbContext in .NET Core for SQL Server Compact (*.sdf File) database
- UPDATE on two INNER JOINed tables in SQL Server Compact 4
- Updating local SQL Server databases with ClickOnce Deployment
- Recommendations for detecting updates to prerequisites in Click once app
- How to copy database schema to enother database using SQL Server Compact in C#?
- SQL Compact 4 - Full-text search?
- How to convert SDF file database to SqlServer Database
- How to convert DateTime of type DateTimeKind.Unspecified to DateTime.Kind.Utc in C# (.NET)
- How to check if SQL column datatype is int and change if the condition is true
- Can't get sql server compact 3.5 / 4 to work with ASP .NET MVC 2
- How to subselect in where statement?
- Windows Phone Series: Local SQL Server Mobile/Compact information
- Using Entity Framework with an SQL Compact Private Installation
- Getting the information of a mobile device by connecting to it
- How do I set Identity seed on an ID column using Entity Framework 4 code first with SQL Compact 4?
- Open .sdf file in Visual Studio 2022
- how to open *.sdf files?
- Using Entity Framework with Sql Server Compact Edition without App.Config additions
- How to avoid writing same code for different types
- Using SQL Server Compact 4.0 with Windows Mobile 6.0 and ASP.NET 3.5