Problem in migrating database from Sybase to SQL Server 2000

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Problem in migrating database from Sybase to SQL Server 2000

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-09 : 08:26:06

Sandeep writes "Hi All,

I tried to migrate my database in Sybase to SQL Server 2000 with help of enterprise manager DTS packages. The data was imported successfully but for columns that have money as data type, the trailing zeroes in the value were truncated.
For eg.
1. In Sybase :

select customer_payment, payable_commission_amount, opening_contingency_balance, chargeback_amount, commission_pay_period, contingency_adjustment_amount, gross_comm_change_amount from dbo.TBL_CONTRACT_COMMISSION_DETAIL
where commission_item_number=111117635832

result :
100.00 100.00 212.67 0.00 200206 100.00 0.00

2. In SQLServer (migrated with DTS Package) :

select customer_payment, payable_commission_amount, opening_contingency_balance, chargeback_amount, commission_pay_period, contingency_adjustment_amount, gross_comm_change_amount from dbo.TBL_CONTRACT_COMMISSION_DETAIL
where commission_item_number=111117635832

result :
1.0000 1.0000 212.6700 .0000 200206 1.0000 0000

As you see the values which are multiple of 10 have been truncated.

Can somebody guide me why this is happening and how if possible can this be avoided"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-09 : 16:47:10

Create the schema manually in SQL Server using the appropriate data type. Then transfer the data. Do not let DTS decide on data types.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources