SqlDbx
You are not logged in.
Exporting multiple tables to a single XML file will be very handy and able to parse and import multiple tables from that XML file to a database will be a very nice feature for sqldbx.
XML output should be;
<MOTree>
< MO TableName="Table1" >
<attr name="column1">value</attr>
<attr name="column2">value</attr>
</MO>
< MO TableName="Table2" >
<attr name="column1">value</attr>
<attr name="column2">value</attr>
.
.
<attr name="columN">value</attr>
</MO>
</MOTree>
Than, maybe this feature could be supported by command line by sqldbx.
Offline
I think it's a good idea. Then not only you can
import data but if we save column info to xml then
it will be possible to create tables too.
Offline
Yes, it is a good idea if you are importing at the same platform.
For cross platforms ; for example; if I want to import a table from Sybase to Oracle data types will not match. Is it possible to handle this?
I think making data types optinal while export/import will be more convinent.
Offline
Yes it is possible to match data types. This is what we
do internally in SqlDbx anyway.
Offline
is there any plans for this request. We would really like to see this feature in sqldbx.
Offline
There will be some changes made to export / import in SqlDbx in a next release.
Will need to think about how to implement something like this in consistent
and useful way
Offline
Current export/import functionality is broken for Sybase I think. I didn't manage to import an exported file with sqldbx. You should make some improvements for applying export/import in a consistent way.
Offline