View database

Discussion in 'Databases' started by Harikrishnan, Jul 20, 2011.

  1. Hi,

    1. How restore the back up of my database in SQL 2005 Database, which is in my client system and restore in Windows 2008 R2 in server.

    2. After restoring, how can I view the tables and procedures. Is there any user interface for the same.

    3. Can I run the script to upload database. Is there any user interface for that

    Thanks & Regards,

    Harikrishnan
     
  2. 1. You can use the built in SQL tools that we have to restore your local database to our environment:

    http://support.Winhost.com/KB/a771/how-do-i-generate-or-restore-a-backup-of-my-database.aspx

    2. You can manage you database by using SQL Management Studio, the following will show you how to connect to your database using SSMS:

    http://support.Winhost.com/KB/a689/how-to-connect-to-sql-server-2008-using-sql-server.aspx

    3. We have some instructions in the following knowledge base article if you would like to script your database to our local environment:

    http://support.Winhost.com/KB/a694/publishing-your-sql-2008-database-to-Winhost-sql-2008-server.aspx
     
    Last edited by a moderator: Oct 14, 2015

Share This Page