473,320 Members | 1,976 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.

How can i deploy a database with Membership Tables?

Hi Everyone!

I have a problem here.
I have used the latest asp.net membership & profiles functionality in
my site.

I have 2 roles admin and user.
I also have a user named admin.

Now, my website is running perfectly, but i want to deploy it.
My database has those tables developed by me and also membership
tables (which were
created by using aspnet_regsql wizard).

Do i need to run aspnet_regsql on hosted database? Is it possible to
do that?
Although i have programming experience. I have no deployment
experience.

How can i sucessfully deploy my website? So that i don't loose any of
my data and it works
fine with all the nice membership features?

2nd Question is just for my curiosity: is it necessary that i need sql
2005 only. Is Membership table supported in sql 2000?

Hope to receive a reply asap.

Regards,
Mahernoz

May 18 '07 #1
5 2883
It depends on your set up on the other side. Possibilities:

1. Have a production server that allows database attach. If so, deploy with
the SQL database and change the connection string to use the attach syntax.
You wil then be up and running. This is common in scenarios with SQL Server
Express.

2. Have a database on the production server (or another machine). If this is
your network, you can copy the file and attach it. If an ISP, you can use
the SQL import/export to the address supplied for your database and migrate
all of the tables/data. You then adjust the connection string to fit the
connection string needed for this database.

Do you see a trend? It is always attach data or migrate data and then change
the connection string.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

************************************************
Think outside the box!
************************************************
"Mahernoz" <ma******@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...
Hi Everyone!

I have a problem here.
I have used the latest asp.net membership & profiles functionality in
my site.

I have 2 roles admin and user.
I also have a user named admin.

Now, my website is running perfectly, but i want to deploy it.
My database has those tables developed by me and also membership
tables (which were
created by using aspnet_regsql wizard).

Do i need to run aspnet_regsql on hosted database? Is it possible to
do that?
Although i have programming experience. I have no deployment
experience.

How can i sucessfully deploy my website? So that i don't loose any of
my data and it works
fine with all the nice membership features?

2nd Question is just for my curiosity: is it necessary that i need sql
2005 only. Is Membership table supported in sql 2000?

Hope to receive a reply asap.

Regards,
Mahernoz

May 18 '07 #2
If the server is yours then yes, you can run aspnet_regsql. If you're being
hosted you won't have access to aspnet_regsql but once you use the host
providers control panel to create a new database you can run scripts that
will do the same thing as running aspnet_regsql from the command line.

Yes, Membership can be used with SQL2000

Cowboy's comments noted, when deploying your data and database to the remote
server you'll have to learn what is called Replication [1].

You'll also want to determine if your hosting service supports the SQL
Server Hosting Toolkit [2].

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/

[1]
http://www.simple-talk.com/sql/datab...on-crib-sheet/
[2] http://www.codeplex.com/sqlhost
"Mahernoz" <ma******@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...
Hi Everyone!

I have a problem here.
I have used the latest asp.net membership & profiles functionality in
my site.

I have 2 roles admin and user.
I also have a user named admin.

Now, my website is running perfectly, but i want to deploy it.
My database has those tables developed by me and also membership
tables (which were
created by using aspnet_regsql wizard).

Do i need to run aspnet_regsql on hosted database? Is it possible to
do that?
Although i have programming experience. I have no deployment
experience.

How can i sucessfully deploy my website? So that i don't loose any of
my data and it works
fine with all the nice membership features?

2nd Question is just for my curiosity: is it necessary that i need sql
2005 only. Is Membership table supported in sql 2000?

Hope to receive a reply asap.

Regards,
Mahernoz

May 18 '07 #3


Check here:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

and

http://www.aspcode.net/articles/l_en...ticle_279.aspx


One way I solved the " here and now there " was to write a little app that
added my

Users
Roles
User (to) Roles.

I have 3 startup text files.
Or you can backup your db, and restore. Or other typical "here and now
there" db scenarios.
I like my little app though, because it makes quick work of deployment.



"Mahernoz" <ma******@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...
Hi Everyone!

I have a problem here.
I have used the latest asp.net membership & profiles functionality in
my site.

I have 2 roles admin and user.
I also have a user named admin.

Now, my website is running perfectly, but i want to deploy it.
My database has those tables developed by me and also membership
tables (which were
created by using aspnet_regsql wizard).

Do i need to run aspnet_regsql on hosted database? Is it possible to
do that?
Although i have programming experience. I have no deployment
experience.

How can i sucessfully deploy my website? So that i don't loose any of
my data and it works
fine with all the nice membership features?

2nd Question is just for my curiosity: is it necessary that i need sql
2005 only. Is Membership table supported in sql 2000?

Hope to receive a reply asap.

Regards,
Mahernoz

May 18 '07 #4

PS

You can write a winforms or console app that hits the membership database.

Just reference System.Web.

"Mahernoz" <ma******@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...
Hi Everyone!

I have a problem here.
I have used the latest asp.net membership & profiles functionality in
my site.

I have 2 roles admin and user.
I also have a user named admin.

Now, my website is running perfectly, but i want to deploy it.
My database has those tables developed by me and also membership
tables (which were
created by using aspnet_regsql wizard).

Do i need to run aspnet_regsql on hosted database? Is it possible to
do that?
Although i have programming experience. I have no deployment
experience.

How can i sucessfully deploy my website? So that i don't loose any of
my data and it works
fine with all the nice membership features?

2nd Question is just for my curiosity: is it necessary that i need sql
2005 only. Is Membership table supported in sql 2000?

Hope to receive a reply asap.

Regards,
Mahernoz

May 18 '07 #5
why not use the free Database Publishing Wizard to create a script of
everything - schema and data -- and run it on the target database?
don't reinvent the wheel.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Mahernoz" wrote:
Hi Everyone!

I have a problem here.
I have used the latest asp.net membership & profiles functionality in
my site.

I have 2 roles admin and user.
I also have a user named admin.

Now, my website is running perfectly, but i want to deploy it.
My database has those tables developed by me and also membership
tables (which were
created by using aspnet_regsql wizard).

Do i need to run aspnet_regsql on hosted database? Is it possible to
do that?
Although i have programming experience. I have no deployment
experience.

How can i sucessfully deploy my website? So that i don't loose any of
my data and it works
fine with all the nice membership features?

2nd Question is just for my curiosity: is it necessary that i need sql
2005 only. Is Membership table supported in sql 2000?

Hope to receive a reply asap.

Regards,
Mahernoz

May 18 '07 #6

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

Similar topics

2
by: Jan and Hugh Tonkin | last post by:
I'm working on a membership database in Access 97 which has 4 datasets, the main one listing current members. When somebody ceases membership, I need to move that member's details from the...
2
by: Arjen | last post by:
Hi, I want to use the aspnet tables (for membership, profiles, roles, etc.) inside my own database. I have succesfully installed these tables. Now I need to tell my application or asp.net 2.0...
0
by: clintonG | last post by:
I applied aspnet_regsql to SQL2K which was working fine throughout Beta 2 development. After installing Visual Studio and SQL Express RTM my application has blown up. Logging in to the application...
5
by: VB Programmer | last post by:
If you want to store custom tables in ASP.NET 2.0, such as Products, Companies, Shopping Carts, etc... where is the standard place to put the tables? I want to link it to the user/membership...
2
by: mel waite | last post by:
I want to create a database using Microsoft access 2003 that is relatively straightforward; it is for a new club that I'm starting. It is quite as small club with only about 100 members maximum, I...
2
by: TJ | last post by:
Hi All, I am having some trouble. I have created a database via the new database option inside VWD2005. Then and table or two. I have been able to perform INSERT and SELECT operations on...
3
by: Michael Lang | last post by:
Hi there, I have a web application that works fine on my local dev machine. However I'm having less success on my hosting environment. When I detach the database for this site, copy it to my...
1
by: =?Utf-8?B?aGZkZXY=?= | last post by:
Hello, I have a web application that makes use of the SQL Membership and Role providers. My app has admin screens to manage users (membership), roles, and supplementary user data. I have just...
1
by: Jeff | last post by:
hey asp.net 2.0 I'm wondering how to add the Membership tables to a database. When I create a website project and wants to register users, users are then automatically registered in the...
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...
0
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...
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: 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...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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....

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.