Re: How can i deploy a database with Membership Tables?



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/database-administration/sql-server-replication-crib-***/
[2] http://www.codeplex.com/sqlhost


"Mahernoz" <mahernoz@xxxxxxxxx> wrote in message
news:1179487049.054276.167720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.


Loading