SSMA 5.2: Duplicate records(Migrate from Sybase 11 to SQL Server 2005)

Question

Hi,

I had converted schema and was trying to migrate data Sybase 11 to target SQL Server 2005 locally through SSMA 5.2. But I have one issue with data. With unique clustered index, it doesn't allow me to migrate data. So first step:I deleted the index manually in targat SQL server. Then try to migrate data but there was first row in two columns(sector,category) are repeating for all other rows for those two columns. See below is source data(total 234  records) and migrated data.

I think this is issue of SSMA 5.2 for migrating data. Is there any workaround for this issue. I have to finish task for my client by EOD tomorrow.

Any help much would be much appreciated!!!

Thanks,

---

ckp

Answer 1

I also tried to manually created unique clustered index at SQL server 2005 as below with option 'IGNORE_DUP_KEY =  ON'

 IF EXISTS (SELECT name from sys.indexes
             WHERE name = N'xdomsta1')
DROP INDEX [dbo].[domstats].[xdomsta1]
GO
CREATE UNIQUE CLUSTERED INDEX [xdomsta1]
   ON [dbo].[domstats] ([sector] ASC,  [date] ASC)
   WITH (SORT_IN_TEMPDB =  OFF, DROP_EXISTING =  OFF, IGNORE_DUP_KEY =  ON, ONLINE =  off)
   ON [PRIMARY]
Go

But i got another weird scenario(just two records migrated) as following:

Table structure :

CREATE TABLE 
[dbo].[domstats]
(
   [sector] char(18)  NOT NULL,
   [category] char(18)  NOT NULL,
   [date] datetime  NOT NULL,
   [short] float(53)  NULL,
   [mid] float(53)  NULL,
   [long] float(53)  NULL,
   [universe] float(53)  NULL
)

---

ckp

Answer 2

Hey Chirag,

Can you please email me your email address to: [e-mail]

I want to discuss.