Upgrading to a 64-bit server from 32-bit. In the process, we're upgrading from SQL Anywhere v12 to v16. This is a critical database (student db) for the university. We would like to take advantage of all improvements, therefore do an unload/reload. There are 3 tables in particular that we know take hours upon hours to reload. To mitigate the downtime, I'm wondering what would be the end effect if we reloaded all but those 3 tables. Once done, we could proxy over to the old database and for those 3 tables, do an Insert into 'new' (select * from 'old'). I've found that to be extremely fast, relatively speaking. Thoughts?
asked 12 May '15, 13:39