Moving a document between servers, databases and tables

If you create a SQL Spreads document and later would like to connect it to a table on another server or in another database you can easily change the server, database or table that a document or worksheet is connected to.

This feature is available from SQL Spreads release 5.0 and makes it possible to develop and test a document against a test version of the database, and then deploy the final document to the production database.

Changing the server


To connect a document to another SQL Server:
  1. Click the Edit link in the Database tab in the SQL Spreads Designer
    .

  2. Select your new server and click OK.

  3. If the new server contains a database and table with the same names, the document will use that database and table.

  4. If the database or the table does not exists in the new server, you will see a dialog to select the database and table to use on the new server:

Changing the database or table  


To use the same SQL Server but connect the document to another table or database:
  1. Go to the Database tab in the SQL Spreads Designer.

  2. Open the new database and select the table to use.

  3. A dialog will let you select how the new table should be loaded. Select the third option Use the setup in the current worksheet:


  4. Click OK.

  5. The worksheet will be refreshed and will now use the database and table.

Changing the name of a database or table in SQL Server


If you have changed the name of a database or table in SQL Server, close and reopen the SQL Spreads Designer by clicking the Design mode button:


SQL Spreads will show a dialog to select the new name of the database and table: 


Click OK and the worksheet will be refreshed and will now use the new database and table name.

Feedback and Knowledge Base