SQL Server Connections

By default, SpeedBase connects to its built-in, file based database and does not require a server machine or installation of a server side software. Starting from version 4.0 and above, SpeedBase supports connection to a remote SQL server so you may keep your database on an SQL server. This option allows you to remotely connect to your SQL server from anywhere around the world via internet.
Before evaluating this option, make sure that you have reviewed all other available connection options given on this page as this option requires more technical skills to setup and maintain.

Requirements



Caution!
SpeedBase does NOT install or manage SQL server software for you. It also does NOT backup your database on SQL server. You must have the required skills and technical knowledge to install, manage your SQL server and deploy an appropriate backup solution. Technical support is only provided for the issues that are related to SpeedBase product and does not cover sql server specific issues.


How to Switch to a SQL Server Database

Note that, even after migrating to SQL server, you may still choose to save file attachments to local data folder. This, however may complicate backing up file attachments on a multiuser license as each user would then save files to the data folder on their own machine. You are recommend to move your data folder to a shared network drive and update connection settings for the shared data folder location on all machines before starting the migration.

Before you can start to use an SQL Server to manage your database, your current data must be migrated to a new, empty database on your SQL server.
Follow the steps given below to setup SpeedBase to use your SQL server to access your database:

Caution!
Files are NOT migrated to SQL Server. If you have attached files to your records, they will still be accessed from your computer or local network.

Caution!
If for some reason you decide to redo the migration of your database, you must first delete the database created on your SQL server and then create a new database.

Caution!
If for some reason you decide to return to your local database, you may do so by adjusting the connection settings. Beware that you may only return to the latest state of your local database just before the migration. It is NOT possible to migrate your current data in the opposite direction i.e. from SQL server database to the local database.

Advanced Users: How to Share Your Existing Data on Your SQL Server With 3rd Party Software or Server-Side Scripts?

Beware that, SpeedBase cannot display or manage your pre-existing data on your SQL server, however, you may create a new database within SpeedBase and then import your existing data into it. This database can then be viewed or processed by both server side scripts or SpeedBase.

Caution!
The database design of the tables and fields created by SpeedBase should never ever be modified by any 3rd party software or script.
The system tables of SpeedBase (which does not contain user data) should also never be modified by other software, neither at design level nor data level.
Doing so may easily result in unpredictable issues, loss of data or corrupted database. No technical support will be provided in such cases.

If you need to modify a user table, add/remove fields, change field properties etc. you must do it using Speedbase application interface only.
All other software may only execute simple SELECT/CREATE/UPDATE/DELETE queries for records on USER defined tables only.

The recommended way to share your data with 3rd party software is as following:
  1. Create the tables and fields in SpeedBase on local database (i.e. on default installation),
  2. Create a new, empty database on your sql server and adjust it to allow remote connections,
  3. Open SpeedBase, open connection settings and migrate your data to this new SQL server database (see above on this page),
  4. Import your existing data to the new database,
  5. Make all necessary adjustments in order any other software or server side scripts to connect to the new database and update data.









Online Help Home Page   ::   SpeedBase Software Home Page