User Guide

Setting Up the SQL Database
6-3
Figure 23. SQL Database Manager and Server Login
On the SQL Database Manager box, click Close. On the SQL Server Login dialog box, at
the SQL Connection drop-down list, select the previously created connection and
click Login. The BMDM program is now ready to use with the SQL database.
6.4. Importing an Access Database into SQL
CAUTION: If the SQL database was previously set up, importing an Access database into the
database will overwrite all existing data. Importing is not a merge function.
String Status > File|Open|SQL-DB
To import an Access database into a new SQL database, select File|Open|SQL-DB. On the
SQL Server Login, click Manage. On the SQL Database Manager, highlight the SQL
database that will receive the Access database, then click Edit. On the Wizard
"Connection Name" dialog box, click Next. On the Password box, type the user name and
password and click Next. On the Wizard "Database Name" box at the Database Name field,
type a new database name or select a name from the drop-down list. Complete
the Access database file path field by clicking the button to the right of the field and
selecting the path/filename for the Access database.
Figure 24. Importing a File into an SQL Database