473,320 Members | 2,054 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

3 questions about scripting the database of a asp.net

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
Nov 6 '08 #1
1 1193

"Jeff" <it************@hotmail.com.NOSPAMwrote in message
news:uq***************@TK2MSFTNGP05.phx.gbl...
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?
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?
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?
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.
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! |
********************************************

Nov 6 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: David Brewster | last post by:
Hi everyone. I've been working with VB6 for a while now, I'm feeling pretty damn confortable with it, but find myself wondering about VB.NET and web applications. So I thought I'd get my feet wet....
19
by: MP | last post by:
I'm interested to learn how to use mdb files via ado/adox via vb6 Since I'm not using Access are those types of questions o.t. here? I see very few ado questions here. But there's a lot more...
6
by: rich | last post by:
I would like to learn more about webdesign. I have my own website that I have handcoded. I do have some javascripts on the site that I have downloaded and have customized and edited to use on my...
3
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ - What questions are off-topic for clj? ----------------------------------------------------------------------- The...
1
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - What questions are off-topic for clj? ----------------------------------------------------------------------- ...
102
by: dreamznatcher | last post by:
Hello, I'm considering a career switch to a more database-related job, but need help on a few questions and issues. I'm a Computer Engineering graduate and have always felt most comfortable...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.