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: Chris Kings-Lynne <Chris.Kings-Lynne AT navitas.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Executing a huge sql script
  • Date: Thu, 14 Nov 2013 02:25:49 +0000

Hmm now I look silly. I didn't even know those utilities existed :/

I tried running it with bsqldb and fisql...but found that it doesn't support
hostname/port connections - only service?

Chris


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Merle Reinhart
Sent: Thursday, 14 November 2013 3:08 AM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] Executing a huge sql script

Does it work when executed with fisql?

Merle



On Nov 13, 2013, at 12:00 PM, freetds-request AT lists.ibiblio.org wrote:

> Date: Wed, 13 Nov 2013 01:19:45 +0000
> From: Chris Kings-Lynne <Chris.Kings-Lynne AT navitas.com>
> Subject: [freetds] Executing a huge sql script
> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> Message-ID:
>
> <a63bc55c022740bfad10d1fbc014fbb6 AT HKXPR02MB007.apcprd02.prod.outlook.com>
>
> Content-Type: text/plain; charset="us-ascii"
>
> 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
--
Message protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.http://www.mailguard.com.au/mg
Click here to report this message as spam:
https://login.mailguard.com.au/report/1InfwajmpY/6ikj4juU1rfHi2rhnOVWlU/1.747






Archive powered by MHonArc 2.6.24.

Top of Page