Skip to Content.
Sympa Menu

freetds - Re: [freetds] Executing a huge sql script

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Cc: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Executing a huge sql script
  • Date: Wed, 13 Nov 2013 07:25:33 +0000

How many characters are the 10000 inserts? How do you pass the query? Tsql?
Perhaps prepared statements have limits while standard (like SQLExecDirect) I
doubt.

Frediano Ziglio

Il giorno 13/nov/2013, alle ore 01:19, Chris Kings-Lynne
<Chris.Kings-Lynne AT navitas.com> ha scritto:

> Hi Guys,
>
> I'm trying to execute a huge sql script via tsql and although it can
> execute from management studio, tsql just fails halfway though. There's no
> error, nothing. It just finishes its 10th set of 1000 inserts (with GO
> between) and simply chooses not to continue on with the next lot, in the
> same file.
>
> Is this something worth looking into? I could replace all the literal
> strings in my file with garbage for testing? The sql file is about 10MB or
> so.
>
> Chris
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page