Post reply

Generate database script

  • March 7, 2012 at 5:12 am

    #252052

    I need to generate database script but my hosting company does not list my database under 'Databases' tab. However I can view and browse tables in Query Pane.

    Please have a look at following screen shot.

    Please advice.

    Thanks!

  • March 7, 2012 at 6:16 am

    #1455930

    You could use the Database Publishing Wizard:

    SQLPUBWIZ SCRIPT -d yourDBName -S yourServerName -U userName -P userPassword scriptFilewithPath

    You can download it from here: http://go.microsoft.com/fwlink/?LinkId=119368

    -- Gianluca Sartori

  • March 7, 2012 at 7:09 am

    #1455971

    What is it that are actually wanting to do ?

    If you want to script up the database so you can create a local copy why not just download the most recent SQL backup from the hosting company (assuming they let you have access - mine does) and restore it on your local machine.

    Alternatively if you want to list what tables etc are in the database, then you can run queries against system views such as :

    select * from sys.tables

    You'd really need to check with your hosting company as to why your database is not listed, but shared host providers do tend to be restrictive with what you can access.

    _______________________________________________________________

    Website : www.sqlmatters.com

  • March 9, 2012 at 12:51 am

    #1456996

    Thanks for replying to my post.

    Using Sql server management studio can I attach database from my hosting server?

    Thanks!

    Zeeshan

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

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