(how) can I copy a table or import/export SQL

Classic Servoy
1

I use the FireBird database and want to copy a table.

This is not a standard feature of Servoy. Is there another way?

Or is there a way to export and import/rename a table?

I work with OS X 10.3.

Thanks…

2

I suggest to get a DB management tool. I know that for under windows you have for example InterBase Expert and EMs InterBase and FireBird Manager. With those tools you can manage your database and run any kind of SQl statement on the DB, including copying tables, exporting data etc.

Paul

3

I’ve seen those too… Under windows… No OS X though…

4

Ooops, forgot to write that I know these under Windows and that I know nothing of OS X… :(

5

On Mac OS X you can use Aqua DataStudio (more info to be posted soon in the Howto section). Unfortunately this tool does not support extraction of metadata and/or duplication of objects as far as I can see so your only option will be to grab a windows box (note that you can access your mac databases from a windows box) or use the command line tools that come with Firebird. If you like command like tools it’s not very difficult, grab the documentation of Firebird to get started here:
http://www.ibphoenix.com/downloads/60All.zip

6

Jan, I don’t like commandtools but I sure know how to use them :lol:

Thanks for the tip!