search

dmusican / enchilada

0 stars 0 forks source link

Backup Database Fail #6

Closed mehdishahid closed 4 years ago

mehdishahid commented 4 years ago

image

I made a parent collection with 15 datasets. After working on some clustering with the datasets, I wanted to backup the collection so as to avoid importing the whole parent collection again.

The menu for the 'Backup/Restore' feature loaded just fine. After naming the backup, an error was received: BackUpFile Error 2

The error log read: BackUpFile Error 3 BackUpFile Error 4

dmusican commented 4 years ago

Thanks -- yep, I see it. The backup code is all SQL-Server-ized. (There were no automated tests for it.) I'll work on it.

dmusican commented 4 years ago

Just following up, since I haven't posted in a while (got busy with other things); I've confirmed that the backup is doing completely SQL Server specific work. I can update that and make backup and restore work again.

Here is one important catch, though. Deborah had mentioned that it would be nice to have the ability to restore into the new SQLite Enchilada a database which had been backed up with the old SQL Server Enchilada. This is very difficult to do. SQL Server uses a proprietary backup format that can really only be read by SQL Server itself. So we'd have to build a tool, or a set of instructions, for restoring the data into SQL Server, and exporting it out again into SQLite format. It appears that there are external tools out there that try to do this, but they won't get right the changes in the database structure that I've made along the way. So even if we got one of those tools working, we'd have to build additional scripting on top of it to go with structural updates.

Again, I'll work on getting the SQLite backup/restore rewritten and up and running. If we truly need to be able to restore old SQL Server backups, however, that's sadly a mess. Anything is doable, but it would be a very time consuming task to do. We would want to seriously examine reward vs. effort necessary.

dmusican commented 4 years ago

Fixed: will appear in the next release. See above comment: we can now backup and restore from the new SQLite version, but we do not have functionality to do SQLServer restores from old versions. We'll let that get filed as a separate issue if it's important enough.