migrate from Oracle to sql server expresse

I want to find out if .net + java + sql server etc is a replacement for my present development environment.

However, I cannot migrate an Oracle database to SQL server express. SSMA does not work. Is there another way to migrate my Oraclke database to SQL server express?

If you are doing development then buy a copy of Dev Edition its $50 from Amazon, its a dev/test use only copy of Enterprise Edition. You can still deploy to express but I recomend using Dev for dev/test

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?