Migrating form Oracle 8 to SQL2000

Has there anyone heard these two 3rd-party tool "SwisSQL" and "DbBest",
which say can full converting Oracle to SQL Server, includes Triggers and
Views?
I got this on KB already
http://www.microsoft.com/resources/...r />
0761.mspx
but I still hope if there're some other choice and much more convenient...I heard of both the products, but I have seen DBBest in action at PASS 2003,
in Seattle, WA. Though I haven't tried it myself, it seems like a very good
product.
This might help:
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"unwar" <anonymous@.discussions.microsoft.com> wrote in message
news:uclsp0xCEHA.1600@.tk2msftngp13.phx.gbl...
Has there anyone heard these two 3rd-party tool "SwisSQL" and "DbBest",
which say can full converting Oracle to SQL Server, includes Triggers and
Views?
I got this on KB already
http://www.microsoft.com/resources/...r />
0761.mspx
but I still hope if there're some other choice and much more convenient...

MID function in SQL?

My brain is not working this morning. Is there a replacement for the MID
function to be used in SQL statements, or even SQL Triggers for that matter?My bad, wrong forum....found it anyway. SUBSTRING()
"Michael C" wrote:
> My brain is not working this morning. Is there a replacement for the MID
> function to be used in SQL statements, or even SQL Triggers for that matter?