AffiniPay

The objective of this article is to export your data from Prolaw to be imported into MyCase. Please note that the success of your data migration into MyCase depends on the quality of your data set. This includes exporting your data in .csv or .xlsx format, ensuring headers are in the top row of the spreadsheet, and removing duplicate entries. If you are unsure as to how to format your data, please reach out to a Customer Support representative for assistance. If eligible for onboarding services, a Data Migration Specialist will assist you in the formatting and organizing of your data.

With Prolaw, users can retrieve a file called a “.bak” file from their Local Server.

- Backup SQL Database to .bak Format
- Obtain .bak File for Migrating to MyCase
- Backing up SQL

Need to have direct access to the local server desktop

Need to have <a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017" rel="nofollow noopener noreferrer" target="_blank">Microsoft SQL Server Management Studio Express</a> installed and running on the server prior to the export.

- Need to have direct access to the local server desktop
- Need to have <a href="https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017" rel="nofollow noopener noreferrer" target="_blank">Microsoft SQL Server Management Studio Express</a> installed and running on the server prior to the export.

Open SQL Server Management Studio Express and connect to the SQL server.

Right-click on the database you want to back up, then select Tasks &gt; Back up. (This is not available for version 2018/2019)

On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.

Select the Backup Type. By default, it is Full - leave it set to that.

Click Remove to remove the default/last backup file name.

Click Add to open the Select Backup Destination window.

Click [...] next to the File Name field.

On the Locate Database Files window, select the folder where you want the backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.

In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.

Click OK to close the Locate Database Files window.

Click OK to close the Select Backup Destination window.

Click OK to start the backup. The progress icon displays in the lower-left corner, and a ‘completed successfully’ message displays when it's done.

1. Open SQL Server Management Studio Express and connect to the SQL server.
2. Expand Databases.
3. Right-click on the database you want to back up, then select Tasks &gt; Back up. (This is not available for version 2018/2019)
4. On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
5. Select the Backup Type. By default, it is Full - leave it set to that.
6. Click Remove to remove the default/last backup file name.
7. Click Add to open the Select Backup Destination window.
8. Click [...] next to the File Name field.
9. On the Locate Database Files window, select the folder where you want the backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
10. In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.
11. Click OK to close the Locate Database Files window.
12. Click OK to close the Select Backup Destination window.
13. Click OK to start the backup. The progress icon displays in the lower-left corner, and a ‘completed successfully’ message displays when it's done.