Looking for import/export tool for 4.04 to 7.1

[gigasoft]

Hello,
We have a a 4.0.4.15848 database on a 2003 server that has been running successfully for years. Unfortunately I am forced to upgrade my hardware to a 2008 64 bit server. This has caused us to upgrade to the latest version of Vault (standard - 7.1.0.2028). I need an import/export tool that works! I am trying export my 4.04 database and I get errors every time I try to export anymore that one folder at a time. I have hundreds of folders to export and then import into my new database. Does anybody have a script or tool that can successfully preform these functions so that I do not have to do one folder at a time? It would be nice if I could start a process that preforms the export operation and has some error handling capability. Any thoughts or help would be greatly appreciated.
Thanks!

[Beth]

When moving to a newer version, you don't want to use Export/Import. Instead, you want to just have Vault upgrade the same database.

Check out our Upgrading Guide posted here: http://support.sourcegear.com/viewtopic ... 13&t=11648&. This route will be significantly faster than using Export/Import.

Here's just a basic overview of what you will do. (Make sure you make a backup of the sgvault and sgmaster databases before starting.)

1) On the Windows 2003 Server, run the Vault 5.1.2 installer. You won't need a license. Just run the server upgrade.

2) On the same server, run the Vault 6.1.0 installer.

3) Backup all the Vault databases again. Restore those databases to your new SQL Server.

4) Install Vault 7.1.0 and allow it to pick up the restored databases. It will upgrade them to Vault 7.1.0.

Clients don't need to go through multiple steps like the server does. The server needs to upgrade the database through the different versions. All previous versions of Vault standard can be found on this page: http://www.sourcegear.com/vault/downloa ... ltstandard. If you need Vault Pro instead, just let me know.

[gigasoft]

Do I need to uninstall the 7.1 installation from my server until the I am ready to restore?

Also if I upgrade to Pro - are all those steps unnecessary?

[Beth]

You will need to uninstall your current installation of Vault 7.1 and allow it to drop the blank databases.

If you are upgrading to Pro, the steps are still necessary, except that you can change the install of Vault 7.1.0 Standard to Vault 7.1.0 Professional.

[gigasoft]

Hey Beth, I finally got to the point of installing version 6.1 on my 2003 server. I had to upgrade to .NET 4 and now I can no longer login as admin(I was able to do that with version 5). For my old login I used to navigate to

https://vaultserver:8443/VaultService/admin

Again I was able to do that with version 5 and 4....but now version 6 gives me the following error...

******************


Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive.

Source Error:


Line 11: debugging ASP .NET files.
Line 12: -->
Line 13: <compilation defaultLanguage="c#" debug="false" targetFramework="4.0">
Line 14: <assemblies>
Line 15: <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>


Source File: C:\Inetpub\wwwroot\VaultService\web.config Line: 13


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3655; ASP.NET Version:2.0.50727.3658

[Beth]

You might need to registry the 4.0 .NET framework. Try the following command:

Code: Select all

C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis -i

[gigasoft]

nope - did not work. Registered and installed all .NET 4 updates, then rebooted the server. Still cannot login and I get the same error.

[Beth]

Take a look in your IIS Manager. What .NET framework are the Vault Application Pools set to use?

Are you still on Windows 2003? If so, since you plan on going to Vault 7.1.0, I would suggest not worrying about Vault 6 and moving onward. The next steps would be to backup the databases and restore them to the machine you want to run the Vault server from. Then install Vault 7.1.0.

[gigasoft]

Okay Beth. Got the database restored to my 2008 server. Re-installed 7.1 server and now I get a login error. It seems that I cannot log into the web. I have installed and uninstalled multiple times and I cannot log in on the web. Is there a way to reset the username and password? Obviously something has been stored some where. Any suggestions? Be nice now


Thanks in advance!

[Beth]

Did you move both the sgvault and sgmaster databases? You'll need both.

What the exact login error?

I can take a closer look if you'd like. Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?

[Beth]

Received email from user. User found that removing and restoring the sgmaster database fixed the issue.