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.
- This options is available in SpeedBase version 4.0 and later versions.
- This option is available only if your license covers "SQL Server Connectivity" component, otherwise you may need to purchase it separately.
- You, or an IT professional in your company must have the necessary skills and technical knowledge to install, configure, manage and backup your SQL server.
You must have a running SQL server installation on a server machine which was configured to accept remote connections.
You may however avoid most of this technical burden by subscribing to a hosted SQL server solution at the expense of the privacy.
- Microsoft SQL server 2005 and above editions are supported. The free version (Express edition) is also perfectly sufficient for most small business applications.
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:
- While not mandatory, you are recommended to complete the initial design and customization of your database on your local computer
before moving it to your SQL server.
- Make sure that your SQL server is configured to accept remote connections.
- Open firewall settings of your server machine and make sure that the port numbers used by your SQL server are enabled.
- Open the management software of your SQL server and create a new database, also assign a user with full modification
rights to this database.
- Open "connection settings" window of SpeedBase, select "SQL Server" from "database type" selection box.
- Enter connection information and then click "Test Connection" to verify that SpeedBase is able to connect to your SQL server.
- Click "migrate" button to start the transferring of all your data to the SQL server. This may take some time depending on the
size of your data. Once finished, the database on your SQL server will be an identical copy of your local database.
- Save changes. All changes you make from now on will be done on the remote database on your SQL server.
- For multiuser connection, go to each of other client computers and just adjust the connection settings to connect to your SQL
server. Do NOT attempt to initiate the migration again.
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.
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.
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.
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:
- Create the tables and fields in SpeedBase on local database (i.e. on default installation),
- Create a new, empty database on your sql server and adjust it to allow remote connections,
- Open SpeedBase, open connection settings and migrate your data to this new SQL server database (see above on this page),
- Import your existing data to the new database,
- Make all necessary adjustments in order any other software or server side scripts to connect to the new database and update data.