Migrating Mediacaster Database to MS SQL Server

There may be instances where it is necessary to convert the Mediacaster Access database to MS SQL Server. If you are running MS SQL Server, upgrading Mediacaster to SQL Server is a straightforward procedure.

Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server. You can download the Microsoft SQL Server Migration Assistant for Access from http://www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB

SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server.

The following steps show the basic process for using SSMA for Access:

1.  Install SSMA for Access.

2.  Open SSMA and obtain a license, as prompted.

3.  Create a new SSMA project for Mediacaster Access Database.

4.  Add the Mediacaster Access database file to the project:

5.  Connect to the target instance of SQL Server.

6.  Convert Access database objects to SQL Server object definitions.

7.  Load the converted objects into SQL Server.

8.  Migrate Access data to SQL Server.
(Note: You can now perform the previous three steps by using the Convert, Load, and Migrate command.)

9.  To make it possible for the Mediacaster application to use the data in SQL Server, link the Mediacaster Access tables to the newly created SQL Server tables.