SqlDbx
You are not logged in.
I tested this feature for Oracle and see that it is not working properly. It is working for Sybase without problem..
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.
locking selected blocks and avoid executing these selected blocks while pressed F5 or CTRL+e might be a usefull feature for Sqldbx.
Also Read only feature applies for whole document. Maybe it could be more useffull if it is applied to only selected blocks.
applying strict row limit like 100 rows while logging output to a file may solve the confusion.
No comments
I’m still thinking that showing and defining remote servers and proxy tables is a reasonable request. Also it is possible to apply this feature for IQ. In Sqldbx, it is impossible to identify proxy tables between usual user tables and find out which proxy table bind to which remote table.
Needed information can be found under sysattributes system table.
I tried to search for an error code under messages tab from huge number of errors. I saw that find option doesn't work under messages tab.
When I try to genearete table scripts without index and constraints, sqldbx generates scripts with index and constarints everytime. I tested it on Sybase ASE 15.0.3 ESD#1
Also is it possible to generate scripts only for indexes or constraints in a database.
When I click on show Sql history, Sqldbx crashes. I tested it at the Personel edition v.3.41.
ability of defining and showing defined remote servers will be a nice feature for SYBASE.
Proxy tables create statements are not shown correctly. they should be as
'create existing table <table_name>(column list) at <REMOTE_SERVER>.<remote_table_name>'
if any proxy table defined under a database they should be shown under a seperate tab other than usual table tab.
Showing sistem performance for Sybase according to MDA tabes will be a nice feature . For example; showing cache hit ratios. network & disk I/O perfromance, executed sql statements with their wait time and wait events... May be this feature can be places at Server explorer.
is it possible to log session input and output to a text file?
this issue is still broken
is there any plans for this request. We would really like to see this feature in sqldbx.
sqldbx can't generate an update script for a record from a view's output. This issue is only valid for views and I tested it on ASE 15.0.2
I limit the returned row number with 100 and queried a table containing more than 1 million rows. It first read the whole table and returned 100 rows and query time took as long as the select result time without using the row limit. I tested it on Sybase ASE 15.0.2.
You added bulk copy support for Sybase and MSSQL but it comes disabled. How can I use it?
Same case also happens while removing multiple favorite objects. It can't remove them at one time.
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.
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.
I agree, it will be very usefull. Basic Bcp parameteres for sybase and mssql are in common. I think it will be much more easier to implement sybase BCP than mssql's bcp.
For sybase, bcp.exe is located under %sybase%/%sybase_OCS%/bin. When connected to a sybase database through sqldbx, it can use this bcp.exe
There is no envoirenment variable defined for mssql side. To locate the exact location of bcp, maybe the best way is to let the user to locate the location of bcp.exe for microsoft.
I am still having problems while dropping multiple tables. Did you have the chance to look at this problem.
I am having this issue at ASE 15.0.2 ESD 6.
Error text: Changed database context to '<Database Name>'. This operation not yet supported. Index =16
When I try to list functions for a specific database from database explorer. Sqldbx gives error.
In addition to this post: Also the same issue happens while trying to export and import XML's.