build database from sql script


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: build database from sql script

  1. #1
    Caroline Guest

    build database from sql script


    I'm new to SQL server and I'm stumped! I have an sql script for a sample
    application and need to build the database. I have installed MS sql server
    (MSDE) and experimented with generating scripts and playing the scripts,
    but I can't figure out how to use them.

    Any help would be greatly appreciated.

    Thanks

  2. #2
    Eric Echols Guest

    Re: build database from sql script


    "Caroline" <cjust@io.com> wrote:
    >
    >I'm new to SQL server and I'm stumped! I have an sql script for a sample
    >application and need to build the database. I have installed MS sql server
    >(MSDE) and experimented with generating scripts and playing the scripts,
    >but I can't figure out how to use them.
    >
    >Any help would be greatly appreciated.
    >
    >Thanks


    If you are using SQL Enterprise Manager, you should do the following(if you
    have the <scriptname>.sql file):

    1. Tools Menu--->SQL Query Analyzer
    2. CTRL+SHIFT+P to open an explorer window
    3. Browse to the <scriptname>.sql file and open
    4. F5 to Execute the script

    This will create the Database, if there are no errors in the script.

    I hope this helps.

  3. #3
    Sreejath S. Warrier Guest

    Re: build database from sql script

    Caroline,
    One way of doing this is to open the script file using a text editor and
    selecting the entire text and copy the same into a query analyzer window and
    run it. You need to log into the query analyzer window using an account with
    DB Creation rights.
    HTH,
    Sreejath S. Warrier
    "Caroline" <cjust@io.com> wrote in message
    news:3ea071b0$1@tnews.web.devx.com...
    >
    > I'm new to SQL server and I'm stumped! I have an sql script for a sample
    > application and need to build the database. I have installed MS sql

    server
    > (MSDE) and experimented with generating scripts and playing the scripts,
    > but I can't figure out how to use them.
    >
    > Any help would be greatly appreciated.
    >
    > Thanks




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center