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

[Gzk2010]

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?

 

[jbenson001]

If you have to combine them, then put the membership tables and SPS in your application DB, not the other way around.

 

[kss444]

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

 

[Gzk2010]

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