Re: [sqlite] .dump - what isn't preserved?

2013-03-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/03/13 04:24, Dave McKee wrote: > What else isn't losslessly maintained in a dump -> load cycle? Various database settings and any strings with nuls in them. Also the sqlite shell expects to be loaded into a clean database. For example it doesn

Re: [sqlite] .dump - what isn't preserved?

2013-03-01 Thread Simon Slavin
On 1 Mar 2013, at 12:24pm, Dave McKee wrote: > I'm considering working with a dump of the SQL database, and I'm anxious to > make sure that nothing gets lost in the transformation. I assume you're talking about the '.dump' function of the shell tool, which creates a set of commands which could

[sqlite] .dump - what isn't preserved?

2013-03-01 Thread Dave McKee
I'm considering working with a dump of the SQL database, and I'm anxious to make sure that nothing gets lost in the transformation. I'm aware that the database will effectively be vacuumed and that rowids won't be preserved. I'm happy about the first and can live with the second. What else isn't