Messages

1

ThumbsPlus v7-v9 Questions / Client/Server Conversion fails instantly.

« on: 2013-07-27 11:14:08 »

I don't remember the exact tweaks. Basically I took the V8 upgradeserver.py file, which contains the sql being executed and copy/pasted each relevant statement into SQL server and ran it manually. Often it failed to create views, columns  and tables because they already existed etc. I'm not a DBA but I have a fair amount of experience with databases in my job (Oracle, SQL Server, DB2) so I just winged it. No hard and fast fix/process I'm afraid.

2

ThumbsPlus v7-v9 Questions / SQL Database Conversion: what is file_time_iso for?

« on: 2013-07-01 05:19:46 »

Hi

Sorry, I didn't run the script in python. I just read it. I could see that the only following steps were to remove some obsolete columns and tables.

3

ThumbsPlus v7-v9 Questions / SQL Database Conversion: what is file_time_iso for?

« on: 2013-06-26 09:28:52 »

Hi I have a massive SQL Server thumbnail database I'm trying to convert to v8 (for use in thumbs 9): some 26 million rows.

The upgrade has been running for about 5 hours and is probably only 5% of the way through.

I've checked the script (upgradeserver.py) and it is very close to the end. The "Populating new Thumbnail columns" step finished relatively quickly, but the slowness is on the "- iso times" step, which appears to be updating the new file_time_iso field to the file's time/date stamp.

After this all that is left to do (I think) is drop some obsolete columns.

However, at this rate the "update_times" step is going to take DAYS.

So my question is: Do I need to let this "update_times" step complete? What's the file_time_iso and thumbnail_time_iso fields used for (beyond being information properties)? What functionality in ThumbsPlus do I lose if kill the upgrade process as is leaving the vast majority of rows with these fields unset?(and probably manually drop the obsolete fields and tables using the script .py script as a guide)?

Many thanks

4

ThumbsPlus v7-v9 Questions / Client/Server Conversion fails instantly.

« on: 2013-06-26 09:12:03 »

Thanks, After some tweaking it has gone through and converted the database.

I have another issue with the length of time one step is taking but that's another topic.

Thanks for the help.

5

ThumbsPlus v7-v9 Questions / Client/Server Conversion fails instantly.

« on: 2013-06-24 17:47:59 »

Thanks for the response.

Just so I understand this fully:  Are you saying that I can use TP8 to do the in place upgrade of the TP7 SQL Server database to a level that will work with TP9?

6

ThumbsPlus v7-v9 Questions / Client/Server Conversion fails instantly.

« on: 2013-06-24 11:07:20 »

Hi, I'm sure this must have been covered but I have not seen anything about re Thumbs 9.

I have a thumbs7 database which I'm trying to convert to work with thumbs9.

I'm quite sure the ODBC connection is correct. I've tried it with the plain SQL Server ODBC driver, and the various SQL Native clients and all attempts fail instantly with:

Opening database for conversion.
Identifying database...
Database server type is Microsoft SQL Server.
Mappings: {u'TEXT': u'ntext', u'COUNTER': u'int identity primary key clustered', u'FLAG': u'bit', u'INT64': u'bigint', u'DATE': u'varchar(32)', u'ID': u'int', u'INT32': u'int', u'INT16': u'smallint', u'BIN64': u'binary(64)', u'BLOB': u'image', u'WCHAR': u'nvarchar'}
Removing pre-v7 cruft.

Conversion failed!

Anyone know where I'm going wrong?

Many thanks.