Dynamsoft provides a tool which allows migration from SourceAnywhere Standalone to SCM Anywhere Standalone. Please note that the migration tool does NOT create a new database for SCM Anywhere. Instead, the tool renames the "SourceAnywhere" database to "SCMAnywhere", and then makes modifications on the database accordingly to make it work with SCM Anywhere.
In most cases, after the upgrade, you do not use SourceAnywhere Standalone, and therefore no need for the "SourceAnywhere" database. If you do need to use SourceAnywhere and the data in the "SourceAnywhere" database after the upgrade, you can follow the steps below:
1. Run the steps 1~6 in this article:
http://kb.dynamsoft.com/questions/439/How+to+upgrade+from+SourceAnywhere+
to+SCM+Anywhere%3F
2. Execute the following command in SQL Server:
alter database SCMAnywhere
MODIFY file
(
name = N'SourceAnywhere',
newname = N'SCMAnywhere',
filename = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SCMAnywhere.mdf'
)
go
alter database SCMAnywhere
MODIFY file
(
name = N'SourceAnywhere_log',
newname = N'SCMAnywhere_log',
filename = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SCMAnywhere_log.ldf'
)
go
3. Under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data on your machine hosting the "SourceAnywhere" database, rename the file "SourceAnywhere.mdf" to "SCMAnywhere.mdf", and rename "SourceAnywhere_log.ldf" to "SCMAnywhere_log.ldf".
4. In SQL Server Management Studio, restore your "SourceAnywhere" database.
Now your "SourceAnywhere" and "SCMAnywhere" databases store the same data, and you can access both databases at the same time.
