October 13, 2002 at 8:44 pm
I'm considering applying for a job working with a Sybase back end. I'm certified in SQL Server 2000. What similarities can I find with Sybase, eg. TSQL language, DBCC commands ?
October 14, 2002 at 5:41 am
Hi,
what i know is from sybase version 11. The dbcc commands are the same, the t-sql does not support the outer join syntacs but the join in the where syntacs. I don't know if that is chnaged in the new sybase version. sybase should support ansi sql. sp_help does also exists in sybase. In http://www.sybase.com/support/techdocs/techtopic you find all kind of information regarding sybase
good luck with the new job
October 14, 2002 at 9:18 am
I think you will find quite a few similarities within the TSQL constructs. Remember MS "created" their RDBMS with a little help from the folks at Sybase. My guess, my last exposure was Sybase 11.0.3, is that 80% of your experience with Microsoft will be applicable to Sybase. The other 20% is learning how Sybase does it.
Be great!
Michael
Be great!
Michael
October 14, 2002 at 12:35 pm
When SQL 7 first came out I was involved with the Y2K project. In that capacity I devised a way to tie serveral non-related Problem Management databases together using SQL7 to pull the data in. I had no idea what Sybase was and we were using 9 or 10 at the time. Took me no time at all to get hooked up and run serveral queries and then play around with Procs, it was quite comfortable. I would say for the most part you will have no issues.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 14, 2002 at 3:44 pm
Sybase runs on Unix platform and SQL Server runs on NT/2000. Some UNIX administration experience is required in order to administrater Sybase well if you want to apply Sybase backend job.
Here is the link talking about migration of Sybase application to SQL Server. It may help you too.
http://www.microsoft.com/sql/techinfo/deployment/70/sybasemigration.asp
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply