Using database for sharing projects

[kpprao]

Hi,

How do we use Database for sharing projects? Any documentation on this?

What advantages do we have in using database for sharing when compared to master/replication method?

Thanks in Advance,
kp

[ltam68]

Hi,

How do we use Database for sharing projects? Any documentation on this?

What advantages do we have in using database for sharing when compared to master/replication method?

Thanks in Advance,
kp

It's quite easy to transfer your existing model to a SQL engine such as MS SQL Server or MySQL.  Press F1 for help and type in the database followed by 'repository'. ie. SQL repository.  There is full instructions on the migration.  

My question to others is how we deal with concurrency in a shared environment?

Cheers,
ltam

[TrtnJohn]

You use package control and a source control repository.  EA will work with common source control tools like MS SourceSafe.  You can source control things at the package level.  If you right click any package and select Package Control you can add it to source control.  (Check the help file for all the details).

Basically it manages locking packages and auto-archiving of XML extracts for you.  It's not the same type of control that you get with something like Visual Studio.  Whenever a package is checked in, the XML export is created and added to source control.  The updates to your database will occur once the user that has the package checked out makes them.  So, these changes will be available immediately.   (Before  they are checked in).

[kpprao]

Thanks for the all the information.

We created database repository using SQL Server 2000. It works fine except that it doesn't have versioning control. So we take database backups every day.

Thanks,
kp