|
|
Posted by serge on 01/26/08 15:08
> It's called the SQL Server Migration Assistant (SSMA) and is free from
> Microsoft. You have to have the .Net framework 2.0 or better on your
> computer, also J# framework, both are free from Microsoft.
>
> Go to this blog for info and a step-by-step Word doc on how to do it.
> http://cfpayne.wordpress.com/2006/07/23/how-to-import-microsoft-access-into-sql-server-2005/
>
> He says you need to dl Sql Server 2005 to your machine, but I used it
> (SSMA) without doing that.
They have an SSMA for MS Access too?
I've used SSMA to migrate Oracle databases and I was happy with the product
since it was easy to use to migrate the data. I only had to migrate the
data.
Converting PL/SQL to T-SQL didn't seem to be 100% efficient but in my
case I didn't need to convert code also.
So as long as it worked for you to get the job done, then it's good.
Navigation:
[Reply to this message]
|