Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export for a table in SQL Server - bug

z0110Nov 25 2015 — edited Nov 25 2015

I have SQL Developer v4.1.2 and connect to SQL server 2008 R2. I can view data in the table without any issue.

However when I export the table (e.g. csv, insert format) by right clicking on the table name and export, I got totally wrong records in the dump file.

Here is why:

1. I have multiple databases in the SQL database server

2. when I try to export a table in the first database, everything seems fine.

3. when I export a table in a database other than the first one, I always get wrong data. As I see here, if the table name exists in the first database, I will get all the data from the first db; if not exist in the first db, I will get empty file.

I believe the tool does not use the database name when exporting, and first database is the default database name for exporting.

Is it a bug?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 23 2015
Added on Nov 25 2015
0 comments
390 views