Backing Up and Restoring Metadata > SQL Server Windows Restore
  
SQL Server Windows Restore
Select the menu option Backup/Restore the metadata (from Sql server bcp) to begin the restore process.
A dialog box will appear. The word RESTORE needs to be entered along with the connection, username and password where the metadata is to be restored to. The metadata will always be restored to the dbo schema. The connection does not have to be that of the current metadata repository, but it must be a valid repository.
Once the OK button is clicked a new dialog box will appear asking for a selection of the export directory. Browse to the contents of the directory where the export is located. Once the export directory is selected the import will begin. A dialog box will appear to show the results of the import.