Some of you might have followed the thread “How can I migrate XML-based C1 site to the SQL Server-based site?” started 1½
months ago – our SQL Server Data Provider was a pricy commercial offering, leaving all our pure open source users with the XML Data Provider option.
Following the threads active period we started asking developers we talked to how they felt about not having SQL Server support out of the box and the reaction we got from them can be summed up as disbelief and disappointment. Generating such feelings in
the core of what we hope to become our community was clearly wrong. Being a newbie organization in the respect to the open source .net community and very happy users of the XML Data Provider ourselves, we missed the simple truth; developers want a data base
they trust, know and can program to host their data. We should have been acutely aware of this when we planned the initial division between our free open source software and commercial extension software.
We will make the SQL Server Data Provider and an “auto-upgrade from XML to SQL” tool available free of charge. The whole thing will be distributed as a C1 Package which allow you to – when needed - very easily migrate all your data and
data schemas from XML files to SQL tables, typically without any need for code changes (LINQ transformations handle this).
You can see LINQ queries, SQL and the migration package in action here:
We will release the package soon after we release Composite C1 v. 2.1 (which should be no later than 5 weeks away). If you want it earlier and are fine with betas, contact me via my CodePlex profile.
Happy hollydays from all of us at Composite - please stay around in 2011 also ;-)