SQL Script to SQL Server DB - Programmers Heaven

Howdy, Stranger!

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

Categories

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.