migrate to MS SQL2000 from Sybase

Could somebody point me to websites that would help in the migration to MSSQL 2000 from Sybase ASE 12.5? I also need replication documents also. We have 7 SQL servers that all replicate and we are thinking about moving to MS because of some benifits for out inhouse program.

thanks for all help..Check out the following article - it is based on sql server 7:

article (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlsm/html/sybase2sql.asp)|||thanks..

Migrate from Sybase SQLAnywhere

I have to convert Sybase SQLAnywhere 8.3 databases to SQL Server 2005
databases. Does SQL Server 2005 come with tools to do this conversion?
Thanks.
Rhea wrote:
> I have to convert Sybase SQLAnywhere 8.3 databases to SQL Server 2005
> databases. Does SQL Server 2005 come with tools to do this conversion?
> Thanks.
This is for ASE:
SQL Server Migration Assistant for Sybase (SSMA Sybase)
http://www.microsoft.com/sql/solutions/migration/sybase/default.mspx

Migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000

How to migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000? Thanks in advance!
1.tools
2.tips
3.problems
I've never performed a Sybase -> SQL conversion, but I can inform you that
MS developed a Sybase->SQL Server migration kit / resource kit which is
available for download from the MS site if you're a MSDN subscriber. The
download is approx 570Mb in total but is was released on CD at one point.
Regards,
Greg Linwood
SQL Server MVP
"Julia" <julia.yu@.acs-inc.com> wrote in message
news:BE0F3811-4927-4650-8F01-9941BAF25BC2@.microsoft.com...
> How to migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000?
Thanks in advance!
> 1.tools
> 2.tips
> 3.problems
|||We recently migrated our product from Sybase ASA to SQL 2000.
Most of our major rewrites were due:
1. Triggers work very differently. There are no row-level triggers in MSS
2. Functions cannot be invoked from procedures in MSS.
Most of the other issues were related to syntatical differences.
Amol.
"Julia" <julia.yu@.acs-inc.com> wrote in message
news:BE0F3811-4927-4650-8F01-9941BAF25BC2@.microsoft.com...
> How to migrate from Sybase SQL Anywhere (V8.02) to MS SQL Server 2000?
Thanks in advance!
> 1.tools
> 2.tips
> 3.problems
|||I really appreciate your response.
I would like to know how to make/change table owner from 'dbo' to
'julia' for all tables? I only know to use sp_changeobject_ownner to
change one table each time.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||I am not aware of any way to change the owner of all the objects in a single
command.
If you post this on microsoft.public.sqlserver.programming you will get a
better response. Most of the SQL Gurus reside there.
Anyway back to your question, I would try to write a small script that would
loop through sysobjects table to get all the tablenames using a cursor and
run sp_changeobjectowner on it.
BTW, In my previous post I said functions cannot be invoked from procedures.
Its the other way around. Procedures cannot be invoked from functions. Sorry
for the typo.
Amol.
"Julia Yu" <julia.yu@.acs-inc.com> wrote in message
news:%23I4qrbiLEHA.1032@.TK2MSFTNGP12.phx.gbl...
> I really appreciate your response.
> I would like to know how to make/change table owner from 'dbo' to
> 'julia' for all tables? I only know to use sp_changeobject_ownner to
> change one table each time.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Middleware to access Sybase databases?

Does anyone use some kind of middleware or linked server
configuration to combine their MSSQL Server data with data
from other relational databases such as Sybase? Thanks
for any help.
SondraHi,
Multiple options , You can either use,
1. Linked server (create a linked server from SQL server to connect to
Sybase or any RDBMS )
2. DTS
3. BCP IN (Sybase), Export ( DB2) , SQLLDR (Oracle) to export data and use
BCP IN in sql server to load
Thanks
Hari
MCDBA
"Sondra" <anonymous@.discussions.microsoft.com> wrote in message
news:5e3801c3e5b3$fc362760$a401280a@.phx.gbl...
> Does anyone use some kind of middleware or linked server
> configuration to combine their MSSQL Server data with data
> from other relational databases such as Sybase? Thanks
> for any help.
> Sondra

Middleware to access Sybase databases?

Does anyone use some kind of middleware or linked server
configuration to combine their MSSQL Server data with data
from other relational databases such as Sybase? Thanks
for any help.
SondraHi,
Multiple options , You can either use,
1. Linked server (create a linked server from SQL server to connect to
Sybase or any RDBMS )
2. DTS
3. BCP IN (Sybase), Export ( DB2) , SQLLDR (Oracle) to export data and use
BCP IN in sql server to load
Thanks
Hari
MCDBA
"Sondra" <anonymous@.discussions.microsoft.com> wrote in message
news:5e3801c3e5b3$fc362760$a401280a@.phx.gbl...

quote:

---

> Does anyone use some kind of middleware or linked server
> configuration to combine their MSSQL Server data with data
> from other relational databases such as Sybase? Thanks
> for any help.
> Sondra

---

Microsoft SQL Server vs Sybase

Hello,

We have Trading Applications (Equities & Portfolio written on C++) on MS SQL Server 2000. Now the management is deciding to move it on Sybase 12.5. We currently don't have any issues on any matter, but because everyone is SYbase fan here, thinks applications are critical and we need to move to Sybase. Can anyone who has worked on both knows the major pros & cons of both the system. Actually I wanted these systems to be on MS SQL Server. I need solid reasons except being cheaper than Sybase to show why we should use MS SQL Server

If anyone can share their experiences, it would be really great.

Thanks
ReaI have used both Sybase ASE and MS SQL Server 2000 in mission-critical systems. Up front I will say that I personally prefer ASE.

ASE and SQL Server have much the same base T-SQL syntax. However SQL Server has introduced a number of functions to do analytics that Sybase thought best to place into a separate product, Sybase IQ. So if you are using CUBE and other functions they will have to be re-written in T-SQL or application logic.

Both ASE and SQL Server have triggers and stored procedures that use T-SQL.

ASE and SQL Server both support user defined datatypes, have identical clustered index approaches, and offer much the same stored procedures to administer the DBMS.

SQL Server has sort of implicit locking scheme in which SQL server will dynamically choose row or page locking (and of course table). ASE requires you to explicitly state whether the granularity of locks are row or page, and a row-lock table cannot lock a data page and vice versa.

ASE has a wider array of tuning tools to change parameters and such. SQL Server has more built-in 'self tuning' tools and can auto-grow devices, auto-backup, etc. Having administered both I prefer ASE's if I have a mission-critical DB that I can devote time to (since our DBAs tend to know more than the server does) but if I want a 'set it and forget it' system I prefer the more autonomous SQL Server.

ASE's next interim release is supposed to have a built-in scheduler feature much like SQL Server. It will have a number of prefab T-SQL templates built in to do things like backups, growing database devices, etc. which helps narrow the feature gap.

ASEs replication, via Sybase Replication Server, is much better than SQL Servers built-in replication. However it is a stand-alone product which costs additional money. ASE does contain ASE Replicator which is a small-scale replication system (I think it maxes out at something like 15 transactions per second) but can be useful if your replication needs are not as demanding for Rep Server.

You can run ASE on Solaris, AIX, Windows, Linux, etc. however SQL Server only runs on the Windows NT family. This can be a big plus if you have competent Unix admins because they can generally tune the system to outperform comparable Windows systems.|||MattR, I was with you up to your last sentance. I have seen Oracle, Sybase and SQL Server run head to head, 10 CPU boxes, 8 + gig of memory and large drive arrays each tunned for the OS/RDBMS. Of course each did some thinges better than the others but at the end of the day there was no "CLEAR" winner. Now that observation was based only on performance. Facter in cost of ownership, cost to impliment, available developers, code base etc... and it was a diffrent picture all together.

Rea, Botton line here is each RDBMS has sommething to offer over the other, you have to look at your needs and decide whit fits your needs best. If the majority of your servers run Unix and the majority of your DB apps use Sybase one has to ask what the benafits of running a few systems under NT/SQL Server are for the company!|||Paul,

That's just my pro-unix bias coming in. :) Generally we've seen more stability from our unix boxen than our NT (NT meaning 2000 and now XP) ones -- I attribute that to better admins being able to poke more at the OS (Linux for example can be ripped apart and pieced back together). But of course we're talking minor differences -- something like a weekly (now more like monthly) reboot on NT on off-peak hours vs. a quarterly one 'for good measure' on the unix ones.

But yes performance shouldnt be the deciding factor you have to take the big picture (TCO) into account.|||Matt, I would clearly take Unix of almost any flavor over a Windows OS. Our NT servers generally run 6 months before needing a reboot but some of our HP servers running HPUX have been up for almost two years!|||I have worked on both the system as a DBA and my personal feeling is that given a choice I would always recommend Sql Server over any database.Reason being Cheap,easily avaliable(resources),a very good tech support,easy to maintain and lot's and lot's of other benefits.
With Sql Server you can reach to the bottom of the problem(Profiler is a great help).
There are some plus points with Sybase which would have been nice with Sql server(like password expring,locking the account),but hey you don't get all the things in one DB.
We were so happy the day we moved from Sybase to Sql Server.
With Sql Server you can control the access of different users at different levels like 'db_dataread/write/denyread/denywrite'.
I would suggest that 'do what everyone is doing and Sql Server is the best choice' specially when you compare Sql Server with ASE.

Just take a small example : You post a Sql Server related problem at www.dbforums.com and within the first one hour you will get the reply,not so with ASE.
;)|||Thanks All of you for your input. Is there any performance gains? Mostly I've heard for very large databse SYbase can handle very well than MS SQL Server, Is it true?|||No, I guarantee you if Sybase is installed on a server with to few resources it will suck wind big time as will SQL Server.

The question should be, what is the hardware cost to properly configure a server to run Sybase Vs SQL Server for MY environment. 8 cpu Sun boxes are cheaper the 8 cpu Intel boxes.|||One more thing with Sybase you need a DBA for things like Backup and Restore,increasing the database size etc etc.
Also the performance is good with Sql Server,it's way way ahead of Sybase.