Results 1 to 5 of 5

Thread: Script creation

  1. #1
    Join Date
    Sep 2007
    Location
    India
    Posts
    21

    Unanswered: Script creation

    Hi

    I am supposed to give scripts for an installtion at client site.

    installing SQL server 2005 Developer edition
    some databases already we have
    tables
    indexes
    Stored procedures
    jobs


    Can u please guide me how to do this?

    I am new to this.

    Muralidaran r

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    I would suggest you get a mentor at your current place of employment.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    In SQL Server Management Studio, right-click on your database and select "Script Database as...".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Dump and restore
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    The jobs will need to be scripted separately from the database, however
    (which, incidentally, irritates the hell out of me).

    Don't forget to check the appropriate options when you are scripting though, and remember that sp_change_users_login can be helpful to get your userid's back in synch.

    Mi Perro, you have a huge pile of work before you...if'n I was you I'd start (a) asking for a mentor at my place of employment, (b) ask if perhaps this task can be given to someone who is not "new to this", (c) updating my resume, or (d) all of the above.

    If this is anything other than a training exercise, and you are actually building a representative product at your client's site, you probably need to be more than "new at this", and hopefully your company management would agree.
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •