The leading provider of version control solution and TWAIN SDK

How to restore the "SourceAnywhere" database after migratiing to SCM Anywhere?

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.




Article Details

Last Updated
23rd o July, 2009

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions (0 votes)

No users have voted.

How would you rate this answer?



Thank you for rating this answer.

Related Articles

Attachments

No attachments were found.

Visitor Comments

No visitor comments posted. Post a comment

Post a comment

To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.
   Name:
   Email:
* Comment:
* Enter the code below:
 

Continue