3 questions about scripting the database of a asp.net

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

hi

asp.net 2.0
sql server 2005 (I'm using that Express version)

I have a asp.net project here which I'm wondering how to deploy the database
of. Right now I locally created a database and created it's tables and
procedures. and used aspnet_regsql to create membership, roles and profile
support etc...

questions:
#1
Can I script the tables and procedures created by aspnet_regsql, So that I
don't need to run aspnet_regsql for each database?
what is best practice scripting them?

#2
My project has 2 roles: Administrator and Normal. Right now these roles
isn't created by the script I created. Is it normal to create a script which
creates roles? if so how do I go about create that script which create the
roles? I mean I guess it's not just one table I need to modify to create the
roles, maybe instead of inserting the roles there are some stored procedure
I can use, if so what procedure?

#3
I have a user registered in aspnet_Users (member of Administrator role), Can
I script this user to so that this user is automatically created when the
script is done?

The goal is that when the script is done the database is created with all
it's tables, procedures, roles and default users.

Best Regards
 
Jeff said:
hi

asp.net 2.0
sql server 2005 (I'm using that Express version)

I have a asp.net project here which I'm wondering how to deploy the
database of. Right now I locally created a database and created it's
tables and procedures. and used aspnet_regsql to create membership, roles
and profile support etc...

questions:
#1
Can I script the tables and procedures created by aspnet_regsql, So that I
don't need to run aspnet_regsql for each database?
what is best practice scripting them?
Click to expand...

The script, as it stands intially, is available at
C:\Windows\Microsoft.NET\Framework\v2.0.50727. See the scripts that start
with Install...

If you have other things you have seeded, then download the Database
Publishing Wizard from Microsoft:
http://tinyurl.com/yuko4v
#2
My project has 2 roles: Administrator and Normal. Right now these roles
isn't created by the script I created. Is it normal to create a script
which creates roles? if so how do I go about create that script which
create the roles? I mean I guess it's not just one table I need to modify
to create the roles, maybe instead of inserting the roles there are some
stored procedure I can use, if so what procedure?
Click to expand...

Try the Database Publishing Wizard:
http://tinyurl.com/yuko4v
#3
I have a user registered in aspnet_Users (member of Administrator role),
Can I script this user to so that this user is automatically created when
the script is done?
Click to expand...

Try the Database Publishing Wizard:
http://tinyurl.com/yuko4v
The goal is that when the script is done the database is created with all
it's tables, procedures, roles and default users.
Click to expand...

The wizard will do that for you.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
 
Back
Top