Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have 2 databases my web app connects two, do I need to combine them

Status
Not open for further replies.

Gzk2010

Programmer
Aug 17, 2010
48
US
OK , I am trying to web deploy my web app made in VS2010 onto one of winhost.com's IIS 7 servers. I ask you and not them becuase I want to know from experienced developers how I may be able to do this. my accouint with them I only have 1 database to use sql2008. But on my local I have the database for the web app, and the Membership database for log ins. Do you think I can just put my sprocs, and tables from my my app DB into the Memebership db and just change connection string and it will work?
 
If you have to combine them, then put the membership tables and SPS in your application DB, not the other way around.
 
in your C:\Windows\Microsoft.NET\Framework\v2.0.50727 folder should be some sql scripts that you can run on your DB to get all the membership tables.

Ordinary Programmer
 
Thank you Kss444 and jbenson0001.

I am going to use the sql2008 gereate script task to get tables and data and any sprocs to my apps db.

Then back back up the db, ftp my .mdf to my hoster, and restore on my hosting webserver. and see what happens!

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top