SSMA - "Default Database is not accessible"

microsoft.public.sqlserver.tools

18 Apr 2006 12:58 AM

shearichard

Hi - i'm trying to use SSMA to migrate from Oracle 10g. I don't yet
have a full SQL Server environment so to test things out i'm using MSDE
(the migration target is SQL Server 2000).

I can connect to Oracle no problem but when i try to connect to MSDE I
get "Database Specified Does Not Exist or is not accessible".

This is quite true - I installed MSDE (in the process creating a named
instance and the sa account) but I have done nothing else (that's what
i'm hoping SSMA is going to do ;-).

So what i should enter as a database when what i'm really trying to do
is get SSMA to create one ? Or should i use OSQL to create an empty one
? Any tips on how to do that ?

thanks

Richard.

20 Apr 2006 11:36 AM

shearichard

OK I'll answer my own question ;-)

It turns out that yes you need to create your own database as a target
before trying to use SSMA.

For those (like me) who know more about Oracle then SQL Server this is
a good resource ...

http://tinyurl.com/o4jd6

regards

richard.