logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Database publishing wizard
Options
Go to last post Go to first unread
Previous Topic Next Topic
marty1101  
#1 Posted : Thursday, February 22, 2007 2:19:00 AM(UTC)
marty1101
Rank: Newbie

Reputation:

Groups: Member
Joined: 2/18/2007(UTC)
Posts: 4
Man
Location: Taiwan
I have hosted my site here. Can I use "Database publishing wizard"?
http://www.codeplex.com/...se%20Publishing%20Wizard

I'm not sure if this tool can solve my problem yet.

Actually, here is what I want to do:
1. I have Visual Studio 2005 and Visual Web Developer 2005 Express
2. I have SQL Server 2005 in machine A and SQL Server 2005 Express in machine B
3. I want to develop a ASP.NET 2.0 application with "Membership", so there is a ASPNETDB.MDF in \App_Data
4. How do I deploy this application to the server?
5. I have several databases used by the application in machine A's SQL Server 2005. How do I upload to/replace with/synchronize with my site's database?

I assume there're some useful tools that can help me work with the hosted environment better. Please advice.

Thanks!

Edited by user Thursday, February 22, 2007 2:30:06 AM(UTC)  | Reason: Not specified
Back to top
WWW

Wanna join the discussion?! Login to your HostingFest Forums forum account, or Register a new forum account.
Back to top  
tareq  
#2 Posted : Saturday, February 24, 2007 11:00:50 PM(UTC)
tareq
Rank: Member

Reputation:

Groups: Member
Joined: 5/20/2006(UTC)
Posts: 15
Man

I think u can use the publishing wizard but before that you must do the following :

1-Create the databases in your the control panel .
2-You need to change the name of the database (aspnetdb.mdf) because your are in a shared environment .
3-you need to change your web.config to match the connection string (see KB).
4-you need to change the membership provider to match the new db which is something like this :
<providers>
<remove name="AspNetSqlMembershipProvider" />
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0,
ulture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="The name of your connection" ........

After that i think you can publish your data .
Back to top
Smiling4ever  
#3 Posted : Sunday, February 25, 2007 2:35:55 AM(UTC)
Smiling4ever
Rank: Administration

Reputation:

Groups: Administration, Member
Joined: 1/3/2006(UTC)
Posts: 348
Man

Was thanked: 1 time(s) in 1 post(s)
tareq wrote:

I think u can use the publishing wizard but before that you must do the following :

1-Create the databases in your the control panel .
2-You need to change the name of the database (aspnetdb.mdf) because your are in a shared environment .
3-you need to change your web.config to match the connection string (see KB).
4-you need to change the membership provider to match the new db which is something like this :
<providers>
<remove name="AspNetSqlMembershipProvider" />
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0,
ulture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

connectionStringName="The name of your connection" ........

After that i think you can publish your data .


Thank you Tareq,

Did you try this marty1101 ?
Noman Dormosh

HostingFest
Back to top
WWW
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET
This page was generated in 0.086 seconds.