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!

T-SQL Capabilities

deep_tech_diverDec 31 2009 — edited Jan 4 2010

We are primarily an Oracle shop, but many of our third-party applications run on SQL Server. I serve as both an Oracle DBA and our SQL Server DBA, and often have to manage data between the two platforms. For instance, our Help Desk Ticket system is on SQL Server, but we do all reporting, and integration with other data, on Oracle, therefore I have a nightly data feed that pulls the data across. I was very excited that SQL Developer has SQL Server capabilities, especially as I am doing cross-platform work. I tried to run some T-SQL in SQL Developer this morning and it gave me the following error:

Error report:
Invalid JDBC escape syntax at line position 27 '=' character expected.

I am assuming this is because SQL Developer does not currently handle T-SQL. Will we ever see this capability from this tool?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2010

Added on Dec 31 2009

#sql-developer

4 comments

4,255 views