---
title: "Switch Server, Database, or Table"
slug: "moving-a-document-between-servers-databases-and-tables"
description: "Point an existing SQL Spreads document at a different server, database or table, so you can build against test and deploy to production."
updated: 2021-04-08T04:37:53Z
published: 2021-04-08T04:37:54Z
canonical: "sqlspreads.com/moving-a-document-between-servers-databases-and-tables"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Switching to another server, database or table

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.

### Switch to another SQL Server

To connect a document to another SQL Server:

1. Click the Edit link in the **Database tab** in the **SQL Spreads Designer**. ![Moving document 1.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Moving%20document%201.png)
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 exist in the new server, you will see a dialog to select the database and table to use on the new server:

![Database is missing on server.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Database%20is%20missing%20on%20server.png)

### Switch to another 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:**

![Moving document 3.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Moving%20document%203.png)

1. Click **OK**.
2. The worksheet will be refreshed and will now use the new database and table.