Post reply

Database creation script

  • February 11, 2005 at 8:20 pm

    #92439

    Please let me know how can I create a batch file or a executable file which on execution fires a script which can create a database in the SQL server2000. Please give me your valuable suggestions on this since I am creating an Installation file for my package and I want a script which will create a database from windows i.e from the installation file.

  • February 12, 2005 at 4:10 am

    #541927

    HI Rohan,

    I had the same porblem some time back.

    I used VB exe to achieve this.

    This vb reads the SQL script so that i don't have to change exe again and again. Only thing I need to do is update the script.

    Hope this will work for u




    My Blog: http://dineshasanka.spaces.live.com/

  • February 13, 2005 at 1:42 am

    #541956

    Hi.

    Why don't you run OSQL by using a bach file. the OSQL.exe is about 50Kb and recives scripts. evey time you whant to add a new script you only add a new line in the batch file.

    I did it for a package installation for a client of ours. The down side is that the bat file is readable.

    I think this is the most simple way.

    yoav.

  • February 13, 2005 at 7:36 pm

    #541979

    Hi,

      Thanks for your reply. I tried doing that but it is not working. Can you give the syntax of that. Well what I did was

    REM Create Database MyBAse

    osql -username -password -i create.sql

    where create.sql is a textfile which contains the create database commands.

    Waiting for your response,

    Thanks

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

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