Sybase SQL Anywhere
Hello Sybase Experts-
I am familiar with SQL Server and Crystal Reports, and I do a lot of data reporting for several of our business processes. I develop table views, stored procedures, and SQL functions - and then use Crystal for the data output. My company is moving to an SAP platform, and I'm curious to know if "Sybase SQL Anywhere" is similar to "SQL Server Management Studio." Will I be able to do similar things? Are these systems very similar? What are the main differences? Any input would be appreciated.
Thank you,
Marcos
I am familiar with SQL Server and Crystal Reports, and I do a lot of data reporting for several of our business processes. I develop table views, stored procedures, and SQL functions - and then use Crystal for the data output. My company is moving to an SAP platform, and I'm curious to know if "Sybase SQL Anywhere" is similar to "SQL Server Management Studio." Will I be able to do similar things? Are these systems very similar? What are the main differences? Any input would be appreciated.
Thank you,
Marcos
Hi,
I agree with Jim.
But I'd like to know: Have you started using those tools yet?
Regards
David
I agree with Jim.
But I'd like to know: Have you started using those tools yet?
Regards
David
ASKER
Nope, I have no familiarity with SAP or Sybase, so I'm trying to determine which tools I would need for data reporting.
Crystal can connect to Sybase. That is just a different ODBC driver.
The SAP console is a total unknown, but it probably is some user friendly GUI. Just like any delivered apps, most will have some user friendly GUI management tool that is completely separate from the DB management tool like SSMS that a DBA would prefer.
The SAP console is a total unknown, but it probably is some user friendly GUI. Just like any delivered apps, most will have some user friendly GUI management tool that is completely separate from the DB management tool like SSMS that a DBA would prefer.
ASKER
Thanks. I'm interested to know if I will be able to develop SQL Views, Stored Procedures, and Functions - similar to what I do know in SQL Server Management Studio - in the new SAP system.
ASKER
Similar to what I do now, I mean, and if so - what is the best console to do this with?
SAP builds a quite complex data repository. Each release update or upgrade might modify the base tables for your views, even remove your defined objects if not named correctly. Because of all that, it's usually a very good idea to get a SAP consultant involved, at least for starter. It isn't much of a DB matter, because that part doesn't change much with the different DBMS SAP supports.
Hi,
While the dialect might be a bit old, Sybase uses T-SQL, so the language is very similar to MS SQL's T-SQL.
So yes, you can build stored procedures. I can't say I've used views. Functions maybe/maybe not.
The objects have that server.database.dbo.tablen
The tools are more reminiscent of SQL 6.5/SQL7/SQL 2000 than SSMS.
HTH
David
While the dialect might be a bit old, Sybase uses T-SQL, so the language is very similar to MS SQL's T-SQL.
So yes, you can build stored procedures. I can't say I've used views. Functions maybe/maybe not.
The objects have that server.database.dbo.tablen
The tools are more reminiscent of SQL 6.5/SQL7/SQL 2000 than SSMS.
HTH
David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The easiest way to describe it is more like SQL 2000 EM and the Query Analyzer than SSMS.