Post reply

how to correctly copy tables and sprocs from 1 database to another since the website hoster only lets me use 1 database(sql2008), winhost.com

  • June 17, 2011 at 1:06 pm

    #389768

    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?

    I do not mean this on a level of how to generate a create table script and run it on other database, I real mean can you mess with Visual Studious memebership database for log ins by adding object with out messing the memebership database?

  • June 18, 2011 at 8:45 am

    #1340785

    this article gives a good idea on where to place the membership db, since your tracking your own website users your membership database objects would need to be part of a schema within your application db.

    http://www.asp.net/security/tutorials/creating-the-membership-schema-in-sql-server-vb

    Jayanth Kurup[/url]

  • June 20, 2011 at 12:39 pm

    #1341395

    great resource. Working with it now! Seems just what I was looking 4.Thanks!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply