Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

SQL Script to SQL Server DB

ITAITA Posts: 463Member
I have a SQL Server script (*.sql). I want to change this into a SQL Server DB. How do I go about this?

[I'm a complete n00b - I've never used SQL b4]

Please help. Many thanks.

ITA

:-)


----------------------------

Greetings from Scotland

Comments

  • GideonOmegaGideonOmega Posts: 617Member
    : I have a SQL Server script (*.sql). I want to change this into a SQL Server DB. How do I go about this?
    :
    : [I'm a complete n00b - I've never used SQL b4]
    :
    : Please help. Many thanks.
    :
    : ITA
    :
    : :-)
    :
    :
    : ----------------------------
    :
    : Greetings from Scotland
    :


    open the Query analyzer and connect to your server, once there open the sql file with the file menu, and then execute it.
    [blue]
    C:Dos
    C:Dos Run
    Run Dos Run
    [/blue]

  • ITAITA Posts: 463Member

    : open the Query analyzer and connect to your server, once there open the sql file with the file menu, and then execute it.
    : [blue]
    : C:Dos
    : C:Dos Run
    : Run Dos Run
    : [/blue]
    :
    :

    I'm using MSDE (the developer version of SQL Server)
    What's the query analyzer and how do I get to it?
    How do I connect to the server?

    PS - the server starts up when the OS starts


  • GideonOmegaGideonOmega Posts: 617Member
    :
    : : open the Query analyzer and connect to your server, once there open the sql file with the file menu, and then execute it.
    : : [blue]
    : : C:Dos
    : : C:Dos Run
    : : Run Dos Run
    : : [/blue]
    : :
    : :
    :
    : I'm using MSDE (the developer version of SQL Server)
    : What's the query analyzer and how do I get to it?
    : How do I connect to the server?
    :
    : PS - the server starts up when the OS starts
    :
    :
    :
    you will need to install the client tools as well as the server tools, I think then you should have access to the query analyzer(it's basicly a enviroment that you can write and execute your scripts in)
    [blue]
    C:Dos
    C:Dos Run
    Run Dos Run
    [/blue]

  • ITAITA Posts: 463Member
    Will the SQL file build a DB?

    sorry if this sounds dim...

    many thx again
  • GideonOmegaGideonOmega Posts: 617Member
    : Will the SQL file build a DB?
    :
    : sorry if this sounds dim...
    :
    : many thx again
    :
    You can execute scripts that will create the db, but as for the sql file you have, I would have to see it to tell you that.
    [blue]
    C:Dos
    C:Dos Run
    Run Dos Run
    [/blue]

  • ITAITA Posts: 463Member
    if you give me an address I'll send it to you...

    you could use the progheaven(i.e here) mail service to tell me the address if this is too public.

    Many thanks again.

    ITA
  • GideonOmegaGideonOmega Posts: 617Member
    : if you give me an address I'll send it to you...
    :
    : you could use the progheaven(i.e here) mail service to tell me the address if this is too public.
    :
    : Many thanks again.
    :
    : ITA
    :

    if you want to email me just click on my name to visit my page, click on the email link and my email address is listed in there, send it to me and I'll check it out.


    [blue]
    C:Dos
    C:Dos Run
    Run Dos Run
    [/blue]

Sign In or Register to comment.