zedalaye / fbclone

A wonderful tool to take care of your Firebird databases
33 stars 19 forks source link

FBClone does not work well with some dialect 1 databases #4

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Build a database with the attached build.sql
2. Attempt to clone the database with FBClone 

What is the expected output? A successfully cloned database.

What do you see instead? There is an exception on the trigger build:
SQL error code = -206
Column unknown
Y
At line 5, column ..
Column does not belong to referenced table

What version of the product are you using? 2.1.4.0
On what operating system? Windows 7

Please provide any additional information below.
If you use the FBClone dump option, the resulting dump file cannot be used 
create a dialect 1 database because 2 of the variable names are in double 
quotes.

Is it possible to add a parameter to specify a target SQL dialect that might 
avoid these problems?

Original issue reported on code.google.com by buckaroo...@gmail.com on 17 Jul 2012 at 8:40

Attachments:

GoogleCodeExporter commented 9 years ago
Slight correction - Step 1, Build a dialect 1 database with the attached build 
script.

Original comment by buckaroo...@gmail.com on 18 Jul 2012 at 7:40

GoogleCodeExporter commented 9 years ago
fbclone is not intended to be used against dialect 1 databases.

Original comment by pierr...@gmail.com on 9 Nov 2012 at 12:06

GoogleCodeExporter commented 9 years ago

Original comment by pierr...@gmail.com on 9 Nov 2012 at 3:05