Export database to XML and import from it

[bairog]

I use dotConnect for SQLite 5.2.146 + Entity Framework 6.1.0 and Code-First approach.

How can I export database data to XML (or some other format) and import from it?

[Shalex]

Please refer to http://www.devart.com/dotconnect/sqlite ... eDump.html.

[bairog]

Thx.

What will happend if I restore only data from a backup (made with DumpMode.Data flag) to a database which have more tables/more fields in some table?
I mean will it be ok to restore data from previous database version to database of current version (which appeared after migrating for example)?

[Shalex]

The compatibility of the dump depends on the schema changes implemented. We recommend you to open the script generated by SQLiteDump and check whether it is compatible with the new database schema.

[bairog]

The compatibility of the dump depends on the schema changes implemented.

My question is about database growth for now (adding new tables/adding rows to existing table).

And I'm afraid I do not understand exactly what you mean by

open the script generated by SQLiteDump and check whether it is compatible with the new database schema.

Do you mean trying to restore SQLiteDump and if it does not fail - so this dump "is compatible with the new database schema".
Or do you mean something else?

[Shalex]

Do you mean trying to restore SQLiteDump and if it does not fail - so this dump "is compatible with the new database schema".

Yes, I do. SQLiteDump.Backup() generates SQL statements in a text format (see SqlDump.DumpText). This script will be executed on SQLiteDump.Restore().