Page 1 of 1
Export database to XML and import from it
Posted: Tue 27 May 2014 13:03
by 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?
Re: Export database to XML and import from it
Posted: Thu 29 May 2014 13:51
by Shalex
Re: Export database to XML and import from it
Posted: Fri 30 May 2014 05:42
by 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)?
Re: Export database to XML and import from it
Posted: Mon 02 Jun 2014 06:13
by 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.
Re: Export database to XML and import from it
Posted: Tue 03 Jun 2014 04:31
by bairog
Shalex wrote: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
Shalex wrote: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?
Re: Export database to XML and import from it
Posted: Wed 04 Jun 2014 15:07
by Shalex
bairog wrote: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().