Copy a base project on a DBMS?

[John Brand]

Currently on 7.5.850 and using SQL Server 2008. To save going through the DBMS administrator to load a script for each new project I was hopüing there was a way of copying a base project and re-using?
Is this possible? Thanks.

[Geert Bellekens]

John,

The script needs to be used for each new database (to create the tables). After that is done you can do a project transfer from another model to copy it to the DBMS server.

You could ofcourse create a base model in a separate database, and restore a backup of that base model each time you need a new database.

Just curious, why is this a problem? Are you creating a new database for each project?
You do know that it is possible to host multiple models in the same database?

Geert

[John Brand]

Thanks, yes we have multiple databases on the DBMS. I'm looking for the easiest way to start a new project on the DBMS without having to bother the DBMS administrator.

[Geert Bellekens]

I usually ask the dba to restore a backup of one of my other projects to a new database. Next to setting the security that is all the dba needs to do, the rest I can do myself.

But yes, you'll always need the help of the dba to setup a new database. (that's why its interesting to host multiple projects on the same database, then you don't need the help of the dba)

Geert