How to restore my LocalDB into SQL Server?

Since version 5, SourceAnywhere supports Microsoft SQL Server 2012 Express LocalDB. You can choose either LocalDB or your own SQL Server to store your SourceAnywhere database when installing the server.

With LocalDB, you will be able to evaluate SourceAnywhere smoothly without installing SQL Server, or just jump into your project right away after setting up SourceAnywhere service. To learn how to install, please check out Step by Step Setup Guide.

Restore LocalDB into SQL Server

You can restore your LocalDB back into your SQL Server (2012 or above) anytime by following steps.

  1. Open SQL Server Management Studio Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Right-click Databases and click Attach.

  3. In the Attach Databases dialog box, to specify the database to be attached, click Add; and in the Locate Database Files dialog box, select the disk drive where the database resides and expand the directory tree to find and select the .mdf file of the database; for example:

    C:\Program Files (x86)\Dynamsoft\SourceAnywhere Server\data\SourceAnywhere.mdf

Re-install Server and change database engine

Afterwards, please don't forget to re-install Server. A few things are recommended before re-installation.

  • It is recommended that you check in or undo checkout all the checked out items before upgrade.

  • Please back up your SourceAnywhere license keys in Server Manager if you own full licenses.

  • To keep your SourceAnywhere Server settings, please backup sawsconfigure.ini in the installation folder of SourceAnywhere Server.

Download Server installer from here,

Install SourceAnywhere Server. To learn how to install, please check out Step by Step Setup Guide.

  • Select Connect to my own SQL Server in the installation process of the new-version Server

  • You will be prompted whether to keep your existing 'SourceAnywhere' database. Please click on YES button to connect to the existing database. If you click on NO button, a brand new database will be created and it will replace the existing one.

  • Start the SourceAnywhere Service if it’s not done automatically.

If you need any assistance or have any problem, please feel free to contact us.