Is there a way to connect to a Sybase (ASE) database instance using Sql Server Management Studio 2008? I tried using other tools to connect but they are very limited and would like to use SSMS.
On the File menu, select Connect to Sybase. If you previously connected to Sybase, the command name will be Reconnect to Sybase. In the Provider box, select any of the installed providers on the machine to connect to Sybase server.
Use the Connect to Sybase dialog box to connect to the Sybase Adaptive Server Enterprise (ASE) instance that you want to migrate. To access this dialog box, on the File menu, select Connect to Sybase. If you have previously connected, the command is Reconnect to Sybase.
Oracle SQL Developer 1.5 (1.5. 0.53. 38) supports browsing a selection of third party databases; Microsoft Access, Microsoft SQL Server, MySQL and Sybase. Before accessing these databases, you need to download and load the correct third party drivers.
You can use this tool:
SqlDbx
It's great.
As far as i know there is no way to use Microsoft's Server Management Studio. And if you are honest it doesnt make a lot sense either. why should sybase/sap design their servers to work with an application provided from a competitor.
personally i prefer to use isql as client software for sybase servers. if you wish to have a GUI may Sybase Central is an option for you.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With