>28.01.2013 19:48, Helen Borrie wrote: >> A related issue: This particular database has a very large amount of >> metadata and the extract script was rejected by isql -input as being too >> large for its buffer. Do we know what the limit on isql's buffer size is?
At 07:58 a.m. 29/01/2013, Dimitry Sibiryakov wrote: > If nothing changed since I saw it - 64k, maximal size of SQL statement. > There cannot be bigger query in any script. I think the jury is out on that theory. AFAIK, the 64K limit is on the size of one SQL statement. A script is a lot of short SQL statements (on the whole); although of course it can (and this one does) contain trigger and procedure statements that approach the 64K limit, individually. However, since this script was extracted from a living database, there should be no statements in it that exceeded the limit. >It rather look like the script you got is wrong. Missed statement separator or >something like that. Could be - it's a theory, at least. But this script was made by a Firebird SQL tool that overlays isql. It just looks like a straight-up isql -x script, without going through it with a knife and fork. In practical terms, I wouldn't attempt to reconstruct a database with this much metadata without breaking it into smaller scripts. I did attempt it on this occasion because I had asked the programmer to send a metadata-only backup in preparation for remote desktop session. He sent the -extract script instead, because he thought they were the same thing. As I mentioned before, this thread is not to seek tech support but to nail down some undocumented facts. Cheers, Helen ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
