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!

Middle Search Support

Some of the databases that I inherited contain search that are based on finding a string anywhere within a last name such as:

WHERE lastName like '%smith%'

It is desired that each of these names be returned:

Smith
Smithson
Nesmith

What is presently done is that updates to the last name fields trigger that substrings of the last name be sent off into a substring table wtih retention of no 2-char substrings. For these three last names the following would be kept:

(1) Smith, (2) mith, (3) ith and (4) th
(1) Smithson, (2) mithson, (3) ithson, ..., (n) on
(1) Nesmith, (2) esmith, (3) smith, ... (n) th

The where now becomes

WHERE lastNameSub like 'smith%'

This seems to make the search routine by last name faster. I would like to improve on this if I can. Suggestions?

Dave

Hello Dave,

I'm afraid you can't within the core engine alone. Obviously a good indexing strategy will help you, but if we're talking about improving the substring/like search on a character column, apart from indexing, you don't have many options.

As you've discovered, using 'smith%' is much faster then '%smith%' as the optimiser has the opportunity to perform an index scan in the first instance - it does not in the second.

If you are performing a lot of these types of searches, I would look at full-text search:

http://www.databasejournal.com/features/mssql/article.php/3441981

http://www.sql-server-performance.com/tb_search_optimization.asp

Cheers,

Rob