The forum is currently being migrated to a new host. While the migration happens, the old server is still available. Once the new machine is ready, I will copy the database to the new machine. Feel free to ask and answer questions in the meantime.

Many applications of SQL Anywhere involve static data sets that are then used in conjunction with the "dynamic" part of the database - examples are things like product lists and increasingly with the support of spacial data - large geographic data sets.

It would be very useful in these circumstances to be able to ship users a replacement dbspace containing the tables, indexes etc required; rather than having to truncate / load tables etc as at the moment (or use a separate remote database).

Clearly there would have to be some restrictions especially as regards referential integrity between objects in different dbspaces - but these could be fairly strict - (eg if you replace a dbspace all RI pointing to it is dropped and you have to re-create it - or you can't replace the dbspace until all RI pointing to it from outside has been dropped).

asked 08 Dec '14, 09:09

Justin%20Willey's gravatar image

Justin Willey
7.3k128165240
accept rate: 20%

2

Would that suggestion include a "BACKUP DATABASE without dbspace ..." feature?

(08 Dec '14, 09:47) Volker Barth
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:

×109
×22

question asked: 08 Dec '14, 09:09

question was seen: 1,642 times

last updated: 08 Dec '14, 09:47