Media Manager / MSDE Info

TimTyler wrote on 4/30/2005, 5:36 PM

Here's a good reference for MSDE, which is the SQL engine that Vegas 6 uses for Media Manager. http://www.codeproject.com/database/ConfigureMSDE.asp

As far as I can tell, Vegas uses the Microsoft SQL Server 2000 SP3 version of MSDE which is the latest release. However, Microsoft will be releasing the 2005 version called 'SQL Server Express Edition' soon. http://lab.msdn.microsoft.com/express/sql/

If you want to explore the guts of the Media Mgr database, or learn how to backup/restore, edit, and configure the MSSQL db, you can get Microsoft's Enterprise Manager tool for managing MSDE by downloading the SQL Server 2000 Trial at http://www.microsoft.com/sql/evaluation/trial/ The Enterprise Manager tool is included in the package,and will not expire when the SQL Server app expires (180 days). You should probably be careful NOT to install the Trial OVER Vegas' MSDE installation too.

The Media Mgr database's username and password is necessary in order to connect from Enterprise Manager and I could not find that, so I was not able to connect.

I'm no MSSQL expert, and this info is in no way a recommendation. Messing with the database might screw it up and require a Vegas reinstall. Use at your own risk.

Comments

TheHappyFriar wrote on 4/30/2005, 6:17 PM

I wonder if the new SQL server will be compatible. I wonder because v2.0 ov .NET isn't compatible with v1.1 SP1 stuff.

farss wrote on 4/30/2005, 7:09 PM

You can access a SQL server database with MS Access and also import data into an Excel spreadsheet.
Be aware that changes to data in a database is instant unlike a word processor there's no Save! However apart from changing that structure or relationships within the database you're unlikely to fatally screw things up just looking.
What you will need however is the username and password to the database, odd that Sony have it locked / have not published it. Once you can get into it this could open a whole world of interesting possibilities.

Bob.