SqlServer-QA.net

I am using ssma to migrate db from oracle 9i to sql server 2000. I successfully migrated oracle tables,views,procedures,functions etc.. But can you please help me on how to migrate packages,triggers and indexes? Here i can able to view the headings like''Triggers'', ''packages'', ''Indexes'' in SSMA. But none of my oracle objects are displaying ...

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server 2005 offers a number of ...

Virtual labs - in simple words its simple to use where a pre-installed environment is setup to try out /test SQL Server installation for your databses upgrade, that has full-featured labs. Not only this you have an option to download manual with a 90-minute block for each module if you are not sure enough. All you have to do is sign-up (free) on ...

Its good that you have specified the database information by not asking open question, appreciate that. 1) Due to the size specified the nearest one will be SQL 2005 WORKGROUP edition, where you will get more information from updated BOL or thislink. 2)Yes you can have both on the same provided the hardware is capable of handling the load, SQL ...