Executing Very Long SQL Script
Posted: Sat 24 Sep 2005 02:29
Hi
I have a very long SQL script - 30,000 lines. I am trying to execute this using SDAC, but its not really working.
Thanks.
I have a very long SQL script - 30,000 lines. I am trying to execute this using SDAC, but its not really working.
- 1) I tried to use TMSSQL. This complained about the GO statements in the script, along with a couple other errors about @CREATE.
2) I tried to use TMSQuery. This was extremely slow, because I had to parse the 30,000 lines of script, look for GO statements, and build the TMSQuery.SQL property. There are about 25,000 lines of code in the script in a single "GO" block. Adding 25,000 strings to a string list takes a very long time and is unusuable.
Thanks.