Progress on Merging SMS databases

I ran into a bit of a snag with my original plan. I built the framework for parsing the SQL script, one statement at a time, and catered for statements that wrapped over more than one line. It took about two hours to get to the point where I was ready to parse the SQL statements.

Then I remembered why I’ve abandoned previous efforts to do this. Has anyone tried, with ease, to parse SQL in C# code? There’s a whole host of issues involved, which is why we usually go directly to the database using ADO.NET or something similar.

So I gave up with that line of thinking. Right now I’m investigating the Microsoft Synchronization framework, using System.Data.SQLite, to go directly to the database and not use the dump file. Hopefully, reading directly from the tables will make life easier.