Friday, September 28, 2012

Sybase to SQL Server Migration Issues

 Default Date/Datetime format in Sybase Vs SQL Server:

               Default Date/Datetime Format is different for both Sybase and SQL Server.
So we need to change the target system’s(SQL Server) date/datetime format,
based on the source system’s output.I am giving the default datetime formats below.

Sybase Default Date Format:
              MON DD YYYY H: HH:MM: SSS AM

SQL Server Default Date Format:
              YYYY-MM-DD HH:MM:SS

Please click here to know about sybase to sql server migration issues


  1. Thank you for sharing knowledge and thanks for fantastic efforts
    fire fighting academy
    Firefighter I *

  2. Thank you very much for your good efforts and good sharing

  3. Hi Siva - Thank you for the details. Can you please let us know how we can resolve the issue during migration from Sybase to SQL Server so that SQL Server shows the same date time format like Sybase.