I wrote the following text to help with upgrading the SQL database. I think something like this should be prominently displayed (or a prominently displayed pointer to the text) so that people read it *before* attempting to upgrade.
Comments?
Dumping the SQL database. -------------------------
Start the SQL Server and SQL Client as usual.
In the SQL Client, type the following three commands. Type them without any extra white space:
>.../dump.sql \D >
That is, first a line consisting of a greater than symbol followed by the full (!) name of the file in which you want to store the dump. This will redirect future output to the file mentioned. Then a line consisting of just backslash-capital D. This command does the actual dump which is, because of the previous line, stored in the dump file. And finally a line with just a greater than symbol. This closes the file and redirects the output again to the screen.
It is also possible to dump from the command line. Start a SQL Server, and then issue the command
MapiClient -lsql -umonetdb -Pmonetdb --dump > dump.sql
This command will connect to the SQL Server and dump the database into the file dump.sql in the current directory.
Restoring the SQL database. ---------------------------
After having dumped the database per the preceding instructions, it is possible to restore the database using the following commands.
Start the SQL Server and SQL Client as usual.
In the SQL Client, type the following command.
<.../dump.sql
That is, a less than symbol followed by the full (!) path name of the dump file that was produced using the dump instructions.
It is also possible to restore from the command line. Start a SQL Server, and then issue the command
MapiClient -lsql -umonetdb -Pmonetdb < dump.sql