How to export entire database and objects

Discussion in 'Databases' started by gmahler5th, Jan 7, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. gmahler5th

    gmahler5th

    I am trying to copy a database from my local machine to my SQL server hosted by ASP.net

    It is a new database which does not yet exist. How do I create new database?

    How do I copy Objects and SPOCS into my new database using ODBC? I know how to copy the tables.

    Thanks.
     
    gmahler5th, Jan 7, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Bruce, Jan 7, 2005
    #2
  3. gmahler5th

    gmahler5th

    Will my database work if tables are owned by dbo?


    Or do I have to change the ownership of the tables to be the same as my SQL SErver username?
     
    gmahler5th, Jan 7, 2005
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page