Migration Problem - Real Pain !!

[takesoln]

SOS !!!

 

hi !

 

I am trying to migrate data from Sybase to SQL server2000. I have a tool to do that.

I Have to check if the table structure and the data are identical in both the databases ( sybase and SQL server2000)

 

My problem is i have 900 tables and comparing the two manually will take ages ... Is there any other way to do that ? i mean is there any way which will help me do the comparison in a short time ?

 

HELP !!!

[georgepatotk]

i am not sure how to compare it with your tool.

 

If for me, I will write a simpel system to copy every fileds in sybase into SQL server.

 

I means, write a program the get input from sybase and output to SQL server.

during the progress, you could do many comparison as you would like to.

 

Got my idea?

[takesoln]

Hi George !!

 

I understand , but could you please give me the Code for copying sybase data to SQL ?

 

Thanx George

[georgepatotk]

I just have the concept, sorry. I use to copy from Access to SQL before.

 

use ADO.Net to do that. It is very flexible.

[Nerseus]

Our DB Admin uses a SQL Compare Tool. I'm not sure if you have a budget for this or if you want to do it yourself. If you're looking for a tool, search google for "sql compare". I can get you the product our DBA uses if you'd like (it's probably between $100 and $1000... not sure.

 

-Nerseus