July 30, 2006 at 2:20 am
Hi All,
I was assigned a work on migration database from oracle9i to sql server 2000.Please give me Your suggestions and information. How to handle exceptions in sql server and other things relating to migration. I already downloaded Microsoft Tool (SSMA) and tested. You have any experiances and useful links. Pls.....
Thanks in Advance
Ramaa
August 2, 2006 at 8:00 am
This was removed by the editor as SPAM
August 3, 2006 at 4:57 am
Hello,
If you have any questions about sql server, post them in the forums. The scope of your question is rather broad.
Error checking is quite limited in sql server 2000.Basically you have to trap the @@Error variable into a temporary variable and check on that (since it gets reset after each statement)
DECLARE @Errorholder int
SQLSTATEMENT
SET @Errorholder=@@Error
if @Errorholder<>0 /*ERROR*/
BEGIN
August 3, 2006 at 8:04 am
The link below from Microsoft covers all you need to do a clean migration, I have used both in one shop and I don't think you will run into issues except Oracle number data type it covers all numeric data types in SQL Server. So read the document below and see if you can just use DTS to move the data. Hope this helps.
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx?mfr=true
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
August 4, 2006 at 4:20 am
Hi ,
Thank You very much all for your suggestions.
Ramaa
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply