copy one table with values from one data

[Anon]

Hi, it is a interbase question.

I have a table called "areas" which list all usa and canada states/provinces etc. in one of my interbase databases.

i want to copy this table "areas" with the values to a new created interbase database. these two interbase database will be sit at the same server.

could any interbase master tell me how to do it?

i used to write a php page to do this kind copy table between two database task.

hui

[cheald]

You might try using the backup/restore tools in IBConsole. When it comes to moving stuff between databases in SQL, it gets a little dicey. However, you might try that - just back it up and restore to other DB. Also, try copying the gdb file, renaming it, and registering it as a new DB.

I have no clue if these will work 🙂