Home > Archive > MS SQL Server > March 2006 > Security implemented in an MDF - what about deployment?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Security implemented in an MDF - what about deployment?
Progman

2006-03-06, 7:16 pm

I had setup the security from the asp.net configuration. I added roles and
user accounts. It created an mdf file with all the security related tables.

Now Id like to know what will happen when I deploy that MDF, which is a
database to a share web hoststing server. the server has an SQL Server on
it?

What will I have to do? Will I have to transfer that mdf database to the SQL
server one on the web hosting server?




Keith Kratochvil

2006-03-06, 7:16 pm

You need to deploy the database. The database contains ALL the files (data
and log) that have been created for the specific database. At the very
least you will want to "deploy" the log file as well.

I recommend that you read up on BACKUP and RESTORE (or possibly sp_detach_db
and sp_attach_db) within Books Online so that you know what options you have
for deploying your database.

--
Keith Kratochvil


"Progman" <adfawefqw@hotmail.com> wrote in message
news:0OZOf.31559$Nb5.405068@weber.videotron.net...
>I had setup the security from the asp.net configuration. I added roles and
> user accounts. It created an mdf file with all the security related
> tables.
>
> Now Id like to know what will happen when I deploy that MDF, which is a
> database to a share web hoststing server. the server has an SQL Server on
> it?
>
> What will I have to do? Will I have to transfer that mdf database to the
> SQL
> server one on the web hosting server?
>
>
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com