Merge text files
-
Is there a tool that can take say 25 .sql scripts and merge them in order into one huge script? I'm sick of doing db updates one at a time X|
Steve McLenithan
Is Bert Evil? | Homer: "Hello, operator, gimme the number for 911!" -
Is there a tool that can take say 25 .sql scripts and merge them in order into one huge script? I'm sick of doing db updates one at a time X|
Steve McLenithan
Is Bert Evil? | Homer: "Hello, operator, gimme the number for 911!"Try the humble copy command
copy subscript*.sql mergedscript.sqlSearching the web without Google is like straining sewage with your teeth.
Userfriendly, 2003/06/07 -
Try the humble copy command
copy subscript*.sql mergedscript.sqlSearching the web without Google is like straining sewage with your teeth.
Userfriendly, 2003/06/07Good idea! I'll give it a whirl;)
Steve McLenithan
Is Bert Evil? | Homer: "Hello, operator, gimme the number for 911!" -
Is there a tool that can take say 25 .sql scripts and merge them in order into one huge script? I'm sick of doing db updates one at a time X|
Steve McLenithan
Is Bert Evil? | Homer: "Hello, operator, gimme the number for 911!"I may be missing something here, but I used to just concatenate them all together one after the other into one big file with
type a.sql b.sql c.sql > all.sql... - Mike -
Try the humble copy command
copy subscript*.sql mergedscript.sqlSearching the web without Google is like straining sewage with your teeth.
Userfriendly, 2003/06/07 -
Try the humble copy command
copy subscript*.sql mergedscript.sqlSearching the web without Google is like straining sewage with your teeth.
Userfriendly, 2003/06/07Aw, but that's no fun! If you really wanna impress, do something like
for %a in (*.sql) do type "%a" >> merged.sql;) --Mike-- "I'm working really, really fast at the moment, so a 3 minute outage becomes, due to time dilation, a 5 minute outage." -- Chris Maunder, relativistic system administrator Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabber -
Aw, but that's no fun! If you really wanna impress, do something like
for %a in (*.sql) do type "%a" >> merged.sql;) --Mike-- "I'm working really, really fast at the moment, so a 3 minute outage becomes, due to time dilation, a 5 minute outage." -- Chris Maunder, relativistic system administrator Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabberMichael Dunn wrote: Aw, but that's no fun! If you really wanna impress, do something like for %a in (*.sql) do type "%a" >> merged.sql Um, I think we definately need a WTL interface to this, it's just too complex. ;P -Nick Parker
-
Aw, but that's no fun! If you really wanna impress, do something like
for %a in (*.sql) do type "%a" >> merged.sql;) --Mike-- "I'm working really, really fast at the moment, so a 3 minute outage becomes, due to time dilation, a 5 minute outage." -- Chris Maunder, relativistic system administrator Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabberShow off ;P Though I do use the
forcommand quite often.Searching the web without Google is like straining sewage with your teeth.
Userfriendly, 2003/06/07 -
Aw, but that's no fun! If you really wanna impress, do something like
for %a in (*.sql) do type "%a" >> merged.sql;) --Mike-- "I'm working really, really fast at the moment, so a 3 minute outage becomes, due to time dilation, a 5 minute outage." -- Chris Maunder, relativistic system administrator Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabberWhoa! You can do that in Windows? :) -- Now we live in a world of uncertainty Fear is the key - to what you want to be You don't get a say, the majority gets it's way You're outnumbered by the bastards till the day you die...
-
Aw, but that's no fun! If you really wanna impress, do something like
for %a in (*.sql) do type "%a" >> merged.sql;) --Mike-- "I'm working really, really fast at the moment, so a 3 minute outage becomes, due to time dilation, a 5 minute outage." -- Chris Maunder, relativistic system administrator Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabber