Post reply

How to run IDL file to create a SQL Server 2005 database schema.

  • August 8, 2006 at 4:02 pm

    #172058

    I have been given an IDL script file to create a SQL server 2005 database schema. The script also populates some of the database tables that are created by the script. The problem I am having is that I don't have any idea as to the proper way to run the script. Here are some of the questions I have.

    Where on my hard drive do I place the script before running it. Does it need to be in a special directory?

    Do I need SQL server 2005 up and running when I run the script?

    Is their a special command I need to run the script? I am assuming that you just type the name of the script at the command line, and then hit enter. Then the script will activate.

     

    Will someone please help me out?

    Thank you,

    William

  • August 11, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 11, 2006 at 9:48 am

    #654605

    Hello,

    I'm not sure what type of file you were given but if it is to be used to CREATE objects on the database server then using SQLCMD utility will work to get the file read into the server...it should be located here:

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn

    SQLCMD utility:

    http://msdn2.microsoft.com/en-us/library/ms170572.aspx

    http://msdn2.microsoft.com/en-us/library/ms162773.aspx

    Hope this helps...Michelle

  • August 11, 2006 at 9:51 am

    #654608

    And YES, you will need SQL 2005 up and running if the script is expected to create objects in the database instance.

    ...Michelle

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

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