Re: Executing a huge sql script
Chris Kings-Lynne <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <b16dd739e3274e0796771dd7b535755e@HKXPR02MB007.apcprd02.prod.outlook.com> |
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: [email protected] [mailto:[email protected]] On Behalf Of Merle Reinhart Sent: Thursday, 14 November 2013 3:08 AM To: [email protected] Subject: Re: [freetds] Executing a huge sql script Does it work when executed with fisql? Merle On Nov 13, 2013, at 12:00 PM, [email protected] wrote: > Date: Wed, 13 Nov 2013 01:19:45 +0000 > From: Chris Kings-Lynne <[email protected]> > Subject: [freetds] Executing a huge sql script > To: FreeTDS Development Group <[email protected]> > Message-ID: > <a63bc55c022740bfad10d1fbc014fbb6@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 [email protected] 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