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

rsnyder's gravatar image

rsnyder
2415716
accept rate: 0%

I can't give advice but just want to understand: So you are saying it takes waaaaayyyy longer to unload and reload these three tables than to fill them via insert select from proxy tables?

When using proxy tables, do both databases run on the same box (with both a v12 and v12 database engine)?

Have you tried using dbunload -an or -ac which will unload without making an interim copy of the data on disk? I could hardly imagine that this is slower than a proxy insert (which will fill the transaction log in contrast to a reload via LOAD TABLE).

(13 May '15, 03:16) Volker Barth
Replies hidden
1

A bit red-faced here. I found our dba was using sybase central, making the unload/load extremely slow. Going to try your switches suggestion, thank-you.

(15 May '15, 11:42) rsnyder
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×54
×39
×14

question asked: 12 May '15, 13:39

question was seen: 469 times

last updated: 15 May '15, 11:42