Categories :

How to Merge Multiple .sql Tables/files Into a Single File?

1. Goto cmd

2. Type in command prompt
C:usersUsersname>cd [.sql tables folder path ]
Press Enter
Ex: C:usersUsersname>cd E:projectdatabase

3. Type command prompt
C:usersUsersname>[.sql folder’s drive (directory)name]
Press Enter
Ex: C:usersUsersname>E:

4. Type command prompt for marge all .sql file(table) in a single file
copy /b *.sql newdatabase.sql
Press Enter
EX: E:projectdatabase>copy /b *.sql newdatabase.sql

5. You can see Merge Multiple .sql(file) tables Files Into A Single File in your directory folder
Ex: E:projectdatabase

Leave a Reply

Your email address will not be published. Required fields are marked *