Compare 2 database structure

[rusdyrip]

hi all,

i have problem update database.
currently if i have create new table on database.
i must manually add new table on other client (old database)
is there any vb.net syntax to compare 2 database
and make the 2 database have same structure


thx

sory bad english

[debasisdas]

You need to change the structure of the table manually .

BTW what is the database that you are using ?

[rusdyrip]

You need to change the structure of the table manually .

BTW what is the database that you are using ?

i am using firebird sql

and using firebird maestro for the gui

so is there no syntax that check if the field does'nt exist then it will add on old database?


thx

[debasisdas]

You need to do all that manually at database level.