[firebird-support] Newbies queries on type of data files and recovery options

2011-09-28 Thread Rohit Coder
Hi, I am a SQL Server and MySQL developer. I am aware of Firebird but never got opportunity to work with it. I want to use Firebird in one of my upcoming project replacing MySQL. While reading the documentation of Firebird, I learned that it supports single as well as multiple database files

Re: [firebird-support] Newbies queries on type of data files and recovery options

2011-09-28 Thread Norman Dunbar
Hi Rohit Coder, welcome to Firebird! 1. Which is the recommended data file structure: `Single file` or `Multiple files`? I'll pass on this one. I may give wrong information. 2. What is the table and data file max-size for version 2.5? Ditto. 3. What are the common scenarios of a

Re: [firebird-support] Newbies queries on type of data files and recovery options

2011-09-28 Thread Ann Harrison
Hi Rohit, I am a SQL Server and MySQL developer. ] 'welcome! 1. Which is the recommended data file structure: `Single file` or `Multiple files`? Single file. The multiple file structure was invented when databases were bigger than disks. Even the multiple-file configuration mixes

Re: [firebird-support] Newbies queries on type of data files and recovery options

2011-09-28 Thread Markus Ostenried
On Wed, Sep 28, 2011 at 15:58, Rohit Coder passionate_program...@hotmail.com wrote: 2. What is the table and data file max-size for version 2.5? http://www.firebirdfaq.org/faq61/  3. What are the common scenarios of a Firebird data file getting corrupt? In case of a single-file structure, I

Re: [firebird-support] Newbies queries on type of data files and recovery options

2011-09-28 Thread Alexey Kovyazin
Hello, 3. What are the common scenarios of a Firebird data file getting corrupt? In case of a single-file structure, I guess no other files need to be backed up? There are some articles on our site Firebird and InterBase corruptions reasons http://www.ib-aid.com/articles/item70

Re: [firebird-support] Newbies queries on type of data files and recovery options

2011-09-28 Thread Mark Rotteveel
On Wed, 28 Sep 2011 11:52:01 -0400, Ann Harrison aharri...@ibphoenix.com wrote: 2. What is the table and data file max-size for version 2.5? I think it's 32K * the page size. Huge. Hi Ann, I assume you mean something like 2^32 * pagesize, because 32K * a pagesize of 16K isn't that much

Re: [firebird-support] Newbies queries on type of data files and recovery options

2011-09-28 Thread Markus Ostenried
On Wed, Sep 28, 2011 at 18:48, Alexey Kovyazin a...@ib-aid.com wrote: 1) Full hard disk: IIRC in this case Firebird will overwrite the file from the beginning. Not good, but checking for free space on every write would slow down writes too much. Just make sure you have enough space. This is

[firebird-support] firebird web database

2011-09-28 Thread Rohit Coder
Hi, I want to use firebird single file database for my ASP.NET web application. I want to know how to host a firebird DB? Regards, Rohit. [Non-text portions of this message have been removed]

[firebird-support] UDA returning arithmetic exception, numeric overflow, or string truncation

2011-09-28 Thread samcarleton
I am working in an older version of IB that does not have the GEN_UUID() function, so I am working on implementing the function as a UDF, but it is giving me an arithmetic exception, numeric overflow, or string truncation. I looking at the FB source to see how it is implemented there, but

[firebird-support] Not able to migrate MySQL database using:

2011-09-28 Thread Rohit Coder
I tried to migrate MySQL DB to Firebird 2.5 IB DataPump, but migration fails. It successfully gets connected to MySQL (Source DB), but it is unable to set relationship to the Firebird (Target DB). Sometimes it even doesn't displays MySQL Provider in the ADO Source of the Source DB. Is there