Post reply

Merge multiple .sql files into One

  • August 24, 2009 at 6:15 am

    #203996

    Hi Everyone

    I am trying to merge multiple .sql scripts into 1 file so that i can run all the scripts at once.

    Can anyone advice on how can i go about it?

    Thanks in advance for any help.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • August 24, 2009 at 6:51 am

    #1043583

    Long back I did that. I created one batch file to do this. This batch file consists of the location of all the .sql files. This is just a hint. Let all other members know how to do this if you resolve this.

    -LK

  • August 24, 2009 at 6:52 am

    #1043584

    DOS command copy can be used with + as follows:

    copy File1.sql + File2.sql + ... + FileN.sql FileAll.sql

  • August 24, 2009 at 7:06 am

    #1043595

    thanks guys. 🙂

    Also, you can do it with red gate's multiple script, i've found out.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • August 24, 2009 at 7:20 am

    #1043607

    Vow Suresh!!

    I am able to copy this but one extra character () is also introduced here by using copy command. How to get rid of this?

    Lucky

    -LK

  • August 24, 2009 at 9:41 am

    #1043722

    I have tried that also and i dont have that special character appearing.

    It seems like you have an extra character at the end of you script or something (e.g. space)

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

Viewing 6 posts - 1 through 5 (of 5 total)

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