Database issues for SourceGear Vault

[tentnology]

Hi, thanks for your reply for my last post. Vault 3.5.1 works very well now.

Before I subscribed this Gold Support, I ever asked if I can use MS SQL Server 2005 EXpress as my Vault database, I was told SQL 2005 Express is not recommended for very large databases and many developers. Can someone tell me how to determine the size of database and number of developers for SQL Server 2005 Express? What is the detailed limitation for SQL Server 2005 Express if I keep it as Vault database?

Another question I was concerning is about how to updgrade SourceGear Vault from version 2.0.6 into 3.5.1. My previous programs in Vault 2.0.6 used MSDE 2000 as database not SQL Server 2005 Express. Can I transfer those data into my current SQL Server 2005 Express database? If so, how to transfer? I used to recover my backup data from *.sgvbak file within Vault 2.0.6. Can I do the same thing for Vault 3.5.1?

I am now doing AutoCAD ObjectARX programs which have different versions for AutoCAD 2002, 2004 and 2007. The programs for AutoCAD 2002 and 2004 version are almost the same and I can use "Share" to keep these two version updated all the time. However programs for AutoCAD 2007 are quite different from AutoCAD 2002 and 2004 version. I need to maintain it into separate repository. How can I manage these three different version in Vault 3.5.1? Can I set up one repository for AutoCAD 2002 and 2004 version and another repository for AutoCAD 2007 version?

Thanks

[lbauer]

What is the detailed limitation for SQL Server 2005 Express if I keep it as Vault database?

Size limit for a database in SQL Server 2005 Express is 4 GB. I don't think there's a user limit.

Another question I was concerning is about how to updgrade SourceGear Vault from version 2.0.6 into 3.5.1. My previous programs in Vault 2.0.6 used MSDE 2000 as database not SQL Server 2005 Express. Can I transfer those data into my current SQL Server 2005 Express database? If so, how to transfer? I used to recover my backup data from *.sgvbak file within Vault 2.0.6. Can I do the same thing for Vault 3.5.1?

Do you have two installations of Vault -- 2.0.6 and 3.5.1?

For the Vault 2.0.6 installation -- you can restore a backup of the Vault database for 2.0.6 to SQL Server Express 2005, then uninstall Vault 2.0.6 and install Vault 3.5.1. Point the installer to the new database location (use .\sqlexpress or machinename\sql express for the database location.) The database will be upgraded. This database will be separate from the current database you have with Vault 3.5.1.

You could do a folder export\import if you want to move folders from one database to another.

Can I set up one repository for AutoCAD 2002 and 2004 version and another repository for AutoCAD 2007 version?

Yes, you can organize your code this way.

[tentnology]

Hi thanks for your reply but I am not very clear about your second answer--"you can restore a backup of Vault data for 2.0.6 to SQL Server Express 2005". The database I am using for Vault 2.0.6 is MSDE 2000 not SQL Server 2005 Express. Now I want to migrate my data from MSDE2000 into SQL Server 2005 Express. I had run the "restore" within admin tool of Vault 2.0.6 but it doesn't work. The restoration of backup data is still done within MSDE2000. I can't find a way to point my old backup data to new database SQL Server 2005 Express. Could you give me detailed explanation about how to migrate my backup data (*. sgvbak) from MSDE2000 into SQL Server 2005 Express?

I will remove Vault 2.0.6 and keep only Vault 3.5.1 after I complete this migration.

Another question I was concerning is about how to updgrade SourceGear Vault from version 2.0.6 into 3.5.1. My previous programs in Vault 2.0.6 used MSDE 2000 as database not SQL Server 2005 Express. Can I transfer those data into my current SQL Server 2005 Express database? If so, how to transfer? I used to recover my backup data from *.sgvbak file within Vault 2.0.6. Can I do the same thing for Vault 3.5.1?

Do you have two installations of Vault -- 2.0.6 and 3.5.1?

For the Vault 2.0.6 installation -- you can restore a backup of the Vault database for 2.0.6 to SQL Server Express 2005, then uninstall Vault 2.0.6 and install Vault 3.5.1. Point the installer to the new database location (use .\sqlexpress or machinename\sql express for the database location.) The database will be upgraded. This database will be separate from the current database you have with Vault 3.5.1.

You could do a folder export\import if you want to move folders from one database to another.

[lbauer]

The "restore" function in the Vault Admin tool only restores a backup to the current SQL Server instance.

Since you are moving to a different SQL Server installation, the restore operation must be done outside of Vault, using SQL Server tools or commands.

You can download SQL Management Studio, a GUI management tool for SQL Server 2005 and 2005 Express (It replaces Enterprise Manager).

http://www.microsoft.com/downloads/deta ... oContainer

Directions for backing up with SQL Server Management Studio are here:
http://msdn2.microsoft.com/en-us/library/ms177429.aspx

Or you can use the sqlcmd utility. Details and examples here:

http://msdn2.microsoft.com/en-US/library/ms165702.aspx
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
http://msdn2.microsoft.com/en-us/library/ms162773.aspx