Subject | Compare two databases |
---|---|
Author | Martin Catherall |
Post date | 2005-01-18T21:53:53Z |
Hi,
Can anybody please tell me if there is an easyway to compare the table
name in one firebird database to the table names in another firebird
database.
I have been using IBEXPERT but have not found a way to do this.
If there are any other tool avaible to do this I would appreciate
knowing about them.
cheers
martin.
Check out www.ubique.webscape.co.nz <http://www.ubique.webscape.co.nz/>
Ubique --> "Drives Your Business"
W E B S C A P E
PO Box 22571
25 Carlyle Street
Christchurch
http://www.webscape.co.nz <http://www.webscape.co.nz/>
Phone 03 964 4020
Fax 03 365 9115
Email mc@... <mailto:tmc@...>
-----Original Message-----
From: Ronaldo Rezende Vilela Luiz
[mailto:ronaldinho79@...]
Sent: Wednesday, 19 January 2005 9:53 a.m.
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: error when execute script in
isql
I already resolved this problem putting an empty line on the end
of
the sql script.
--- In firebird-support@yahoogroups.com, "Ronaldo Rezende Vilela
Luiz"
<ronaldinho79@b...> wrote:
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
of Service <http://docs.yahoo.com/info/terms/> .
=========================================================
This e-mail has been scanned for Viruses and Content and cleared by CommArc Cube Server
[Non-text portions of this message have been removed]
Can anybody please tell me if there is an easyway to compare the table
name in one firebird database to the table names in another firebird
database.
I have been using IBEXPERT but have not found a way to do this.
If there are any other tool avaible to do this I would appreciate
knowing about them.
cheers
martin.
Check out www.ubique.webscape.co.nz <http://www.ubique.webscape.co.nz/>
Ubique --> "Drives Your Business"
W E B S C A P E
PO Box 22571
25 Carlyle Street
Christchurch
http://www.webscape.co.nz <http://www.webscape.co.nz/>
Phone 03 964 4020
Fax 03 365 9115
Email mc@... <mailto:tmc@...>
-----Original Message-----
From: Ronaldo Rezende Vilela Luiz
[mailto:ronaldinho79@...]
Sent: Wednesday, 19 January 2005 9:53 a.m.
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: error when execute script in
isql
I already resolved this problem putting an empty line on the end
of
the sql script.
--- In firebird-support@yahoogroups.com, "Ronaldo Rezende Vilela
Luiz"
<ronaldinho79@b...> wrote:
>with
> What's the problem? The script historico.sql has been executed
> sucess, but this error is genereated all times when I use theisql.
> The commands of script has been executed in the database.historico.sql
>
> C:\sig_aluguel>isql dados.fdb -u SYSDBA -p dba1379 -i
> Expected end of statement, encountered EOFTEXTO_80
>
> historico.sql
> CREATE TABLE CURSO (CURSO_ID INTEIRO_PEQUENO NOT NULL, NOME
> NOT NULL);(CURSO_ID);
> alter table CURSO add constraint PK_CURSO primary key
> CREATE GENERATOR GEN_CURSO_ID;_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
>* Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service <http://docs.yahoo.com/info/terms/> .
=========================================================
This e-mail has been scanned for Viruses and Content and cleared by CommArc Cube Server
[Non-text portions of this message have been removed]