hello every one,

i have migrated sybase database to sql sererver it seems successfully migrated, we required to validate data and datatype before going to production, how can this be achieved, kind of stored procedure which can be run both sides (sybase and sql) and validated in some way. or any other suggestions.

thanks

I guess you need to physically select all tables and see the data. I dont think there is query/SP to actually check data integrity.

Hi Zeal,

You can consider to export table contents from SQL Server database and Sybase database to files such as Excel and CSV, then compare the outcome that includes data and columns. There is also a similar thread about using application controls to validate data for your reference.

Also you can use DBCC CHECKDB to check logical and physical integrity of all the objects in the specified database from SQL Server. For more information about DBCC CHECKDB, see  http://msdn.microsoft.com/en-us/library/ms176064.aspx .

Thanks,
Lydia Zhang