technique
08-04-11, 10:52 AM
It’s probably easier than you thought, and it can be done via the inbuilt Command Line Client. Go Start>Run and type CMD and obviously start it up. Now move all the .SQL files that you want to merge into one bigger file to a folder and put it in C:/ (Or whatever is your local disc). You can name the folder as you please, I chose to name mine merge. Now in CMD do the following commands and end by pressing enter (See picture below). Choose the name of the single file that should contain all your .sql files as well, simply change ”all” (which will be the name of the merged file) to something else unless you want to keep it – It doesn’t matter as you can rename it later.
http://img683.imageshack.us/img683/8277/cmd1.png
You will now see that all .SQL files in your folder are merged into one big .SQL file and is located in the folder you created, the original files still exists.
http://img683.imageshack.us/img683/8277/cmd1.png
You will now see that all .SQL files in your folder are merged into one big .SQL file and is located in the folder you created, the original files still exists.