Re: [firebird-support] FB1 to FB3

Sorry Carlos - I read that wrong. Thought you were asking if the script could be run with isql. Cheers, Kevin > On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' lis...@warmboot.com.br > [firebird-support] wrote: > > Step 1 is better if you are going from dialect 1 to 3, mostly due to >

Re: [firebird-support] FB1 to FB3

Great - thanks Mark. I only need FR just for that, simple queries and the occasional update/delete sql. > On Apr 30, 2020, at 9:09 AM, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: > > On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com >

Re: [firebird-support] FB1 to FB3

I always tend to do back / restores not only in this migration but on a regular basis. I’m maybe a little on the paranoid side. :) I have noticed some extra lines in the restore log for FB3 (this is true even on a completely new FB3 database): gbak:fixing views dbkey length gbak:updating

Re: [firebird-support] FB1 to FB3

Thankfully I moved from D1 to D3 many years ago. So now just need to get to FB3. Cheers, Kevin > On Apr 30, 2020, at 7:37 AM, 'Jason (PN)' ja...@jac2.co.uk [firebird-support] > wrote: > > Hi Kevin, > > Can I ask what dialect you are going from and to? > > Sorry I don’t have an

[firebird-support] FB1 to FB3

Greetings! Process 1: Via a script, I have successfully exported and migrated all data and objects from a FB1 database to FB3. Creating the objects originally had just a few errors but those have been fixed and it now goes across cleanly, no errors. This process has been the one most widely

Re: [firebird-support] Remote backup using gbak

Mark - thank you very much! I do want the backup file on the server so all is good there. I have found that the spaces do cause an issue. Where I’m at right now is the following: gbak -b -user sysdba -password masterkey -service win2012server:service_mgr c:/~wrk/lumber.fdb

Re: [firebird-support] Remote backup using gbak

The error was: Gbak error: I/O error for file “c:\fbThe system cannot find file specified.” Gbak error: Error while trying to open file. Gbak error: The system cannot find the file specified. Thanks! Kevin > On Jan 1, 2020, at 2:03 PM, Norman Dunbar nor...@dunbar-it.co.uk >

[firebird-support] Remote backup using gbak

Greetings! I’m hoping someone can help me out here. FB 1.56 (upgrading soon), trying to perform a remote backup. Here’s my batch file: cd "c:\program files\firebird15\bin" pause gbak -b -user sysdba -password masterkey -service win2012server:service_mgr "win2012server:c:\fb

Re: [firebird-support] A recommendation (database migration)

I do know that - just have never tried the cross platform yet but would love to. :) Thanks! Kevin > On Dec 2, 2019, at 11:12 AM, Karol Bieniaszewski liviusliv...@poczta.onet..pl > [firebird-support] wrote: > > > >> That’s part of the issue - I’m a Delphi guy and not sure I could

Re: [firebird-support] A recommendation (database migration)

That’s part of the issue - I’m a Delphi guy and not sure I could get it cross platform. > On Dec 2, 2019, at 8:51 AM, Norbert Saint Georges n...@tetrasys.eu > [firebird-support] wrote: > > Kevin Stanton kevin.stan...@rdb-solutions.com >

[firebird-support] A recommendation (database migration)

Greetings! We are in the middle of migrating from FB 1.56 to 3.x. Of course the recommendation is to create a script of the database and run it against FB 3 which we’ve done. We’ve also purchased the Migration Guide to Firebird 3. Now comes the challenge - getting the data over. Some of our

Re: [firebird-support] Off-Topic: Firebird future

That would be awesome. > On Oct 21, 2019, at 10:29 AM, 'Alexey Kovyazin (ak)' a...@ib-aid.com > [firebird-support] > wrote: > > > Hello Stefan, > > > If Firebird users want to have GUI too, we should consider the options. >

Re: [firebird-support] Will we move when yahoo Groups close theirs doors?

Oregon Delphi Users Groups has the same issue. Looks like that group is moving to http://groups.io > On Oct 19, 2019, at 5:01 AM, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] > mailto:firebird-support@yahoogroups.com>> > wrote:

Re: [firebird-support] Migrating from 1.56 to FB 3 - making good progress

Thanks Carlos - I have been reading your book - it’s been a great help. I need to refresh myself with it though. Kevin > On Oct 2, 2019, at 10:53 AM, 'Carlos H. Cantu' lis...@warmboot.com.br > [firebird-support] wrote: > > I guess you can just extract the Procedures and Triggers

Re: [firebird-support] Migrating from 1.56 to FB 3 - making good progress

Cool. I will try the IB Expert Data Export feature first on the new/empty FB3 database. If I have to recompile all objects, is there an “easy” way to do this? Thanks! Kevin > On Oct 2, 2019, at 10:24 AM, 'Carlos H. Cantu' lis...@warmboot.com.br > [firebird-support] wrote: > >

[firebird-support] Migrating from 1.56 to FB 3 - making good progress

Greetings! I have been successfully created a script of the metadata in the 1.56 database, ran the script against FB 3 (all using IB Expert). Initial attempt only revealed about 20 or so errors. Not too bad for a fairly complex 20-year old database. I have fixed all the errors and can now

[firebird-support] Transactions

Greetings, I’m sure this has been asked before - is there a knowledge base somewhere? I’m trying to get a handle on transactions from gstat and I just want to make sure I’m reading this correctly. One of my installs is having some issues, Firebird 1.56, Classic Server. I have been reading

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

Thank you! Thankfully I made the dialect 1 to 3 conversion years ago. I will check these out. It will be a bit before I can devote 100% on this. > On Feb 13, 2019, at 1:03 PM, FSPAPA INCA Team i...@foodstuffs-si.co.nz > [firebird-support] wrote: > > > Hi Kevin – I’ve had good results

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

Thanks Mark. I realize it’s a huge migration. I will be exhaustively testing everything. I like the idea of creating an empty database and pumping the data over. Is there a tool for this? (Actually just found one from Clever Components) I have looked at the migration docs for the 2.x

Re: [firebird-support] Stored procedure stops functioning correctly after restore under Firebird 3

I’m starting to look into migrating from 1.56 to either 2.5 or directly to 3.0. I’ve bought the Migration Guide but haven’t read it yet. It concerns me that I would/will have to recompile all SPs and triggers. Is there an automated way to do this? I have 909 SPs and 785 triggers. This will

[firebird-support] Tools for finding lock conflicts

Greetings, What is the best way to track down a lock conflict on no-wait transaction error? Are there any tools available? Thanks in advance! Kevin