Re: help :Deploying a preconfigured database

See Backup and Restore, or Detach / Attach in BOL.
This may leave the issue that the restored / attached database at the
customer site is not the desired size or placement - you may wish to
pre-extend and specifically initialise the database on a RAID system for
best long term performance. In the case, test out doing a restore to a work
database then using the Transfer Wizard in SQL EM to copy across everything
needed to the manually created and placed database. It is important to do
this as the transfer does not always work 100% - views based on views will
fail if view M refers to view N and view N does not exist when view M is
created...

Rights should be assigned to roles. When the customer adds users the users
should have the needed roles added to grant / deny the required access
internally.
I find it is best to integrate this into the application.

If role based permissions (and this also means employment roles being inline
with access roles) is used then it is a lot easier to manage security.

"serge calderara" <sergecalderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:27085A26-B8F6-465E-B0A5-7EB660D66AC0@xxxxxxxxxxxxxxxx
> Thnaks for your reply.
>
> What about the whole database structure and rights to table and strore
> procedure...
> How to deployed them in a safe and straight way on the target customer
> server and have at the end a traight forward running database copy of what
> has been tested on a test server environement ?
>
> Sorry for the basic question but I am new in SQL and that a customer
> request. never do that before so if you could help me that will be great
>
> Regards
> serge
>
> "Keith Kratochvil" wrote:
>
>> You can use the following KB article to script logins:
>>
>> HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
>> http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133
>>
>> You will want to make sure that you create appropriate script files to
>> set
>> up the logins and assign the permissions. You should be able to run
>> these
>> files via osql.exe (a command line tool). You will want to provide
>> whatever
>> error checking is necessary within the script so that you do not get
>> errors.
>> For example, lets say that your config requires the SQL Server login
>> 'user.'
>> You need to create user. If your script attempts to create user but they
>> already exist an error will be displayed and that could halt everything
>> that
>> comes after that specific point within the script. You will first want
>> to
>> check to see if user exists. If they do, do nothing. If not, add them.
>>
>> --
>> Keith
>>
>>
>> "serge calderara" <sergecalderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:BC62E884-8286-44B9-B68C-D6E92148259F@xxxxxxxxxxxxxxxx
>> > Dear all,
>> >
>> > One of our application consist of configuring an SQL server database
>> > with
>> > user rights to tables and preparing corresponding store procedure.
>> >
>> > usually when we do this, we prepare the server in our test environment
>> > and
>> > then ship the whole hardware pre configure to customers.
>> >
>> > in some cases we do not have the customer server, so we need to do the
>> > whole
>> > configuration on site and in cas of errors its hard to find.
>> >
>> > is there an easy way to prepare the SQL confisuration database, store
>> > procedure, table rights on a test PC, then do a kind of straight
>> > forward
>> > deployement on any server running SQL ?
>> >
>> > thanks for your help
>> > regards
>> > Serge
>> >
>>
>>
>>


.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
Loading