SQL-Database - Tips&Tricks

Mr, Hannes,



Many thanks for your tip & tricks for P5 Installation. I had a hard times to convert my P4.1 to P5 stand alone. Now it works in my laptop. I cannot configure the database using the MSDE attached to the Installation disk, then I downloaded the sql server 2005 express, and it works well!



Benito

Hannes, I’m afraid that I don’t understand your comment, even though I have a general techie background, including programming and databases. (But I confess that was long before anyone knew what SQL was, whether in a database or a programming context!)



But let’s keep things simple, if only for my benefit. In a Primavera sense there is no real difference between a MS SQL Server Express (formerly MSDE) database, a full MS SQL Server database, or an Oracle database.



I’ve never heard of Express being described as part of the Windows operating system. But its use is free of charge for up to eight simultaneous users. Which obviously includes standalone. And it is the default choice for both Primavera standalone and small server installations. But there is nothing to stop a standalone Primavera user using either of the other two if they choose to do so, and are licensed to do so. At one time I used to use SQL Server 2000 for my standalone laptop, because I didn’t like MSDE’s lack of database "tools".



But none of that has anything to do with the question of Primavera application program licensing, which is what I was commenting on.

Oliver, I was specifically describing a scenario that was both server and standalone. In that situation, there would be a server-based licence file that would ordinarily describe multiple users and possibly also different configurations of software used.



As every database has to have an attached licence file, one can’t then also use the server licence file "standalone". There would need to be a different licence file that would be most logically for a single "Named User". And that would require a separate purchase.



The P6 Licence Agreement says that the software is for "a single standalone computer" OR (my emphasis) use on a computer network. But there is a difference between backing up data (including the entire database, as described in this thread) and accessing data using the software.



That’s the kind of explanation I’d give my own users, but you should contact your Primavera rep if there is any doubt.

Arthur,



Are you stating that cannot use a named license to access the original database and copied one at seperate time, as far as license agreements go?

"use databases on other computers".



But be aware of possible licensing implications. It is relatively common that the same person might want to use the Windows client program "Project Management" with a multi-user server-based database, but also standalone. Usually part of the server database would be "checked out", and this ensures that there there is no danger of that data being updated in two places.



In that scenario, even if you are the same user, you need two licences. One for the server and one for the "standalone" database. And although copying the whole database is something different, as far as I know it has the same licensing considerations.

Hi Hannes,



It is vey Important Topic you explained.



Thanks

Ok, need to check with Admin guys as what we hav now is Microsoft SQL Server/SQL Express.



Will call u bak



Cheers,



Ravi

Thanks Hannes,



I have checked the path specified on my system, but its not what u have mentioned. It is



C:\Program Files\Microsoft SQL Server\80\Tools\Binn



and there is no ssmsee.exe file in it.



there are four dll files in it. sqldmo.dll, sqlresld.dll, sqlsvc.dll and w95scm.dll



Will u plz elaborate more on this. Y this ssmsee.exe file is not there opn my system.



??????

Hannes,

It helps a lot,

Thank you