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.




Online Help Home Page   ::   InfoLine Software Home Page