MySQL to Mssql

MySQL to Mssql



There was a necessity to change a database server with mysql on mssql.
Database change has passed successfully, but at restoring backup there was an error.


 


*********************************************************************************
    Restore DB Setup Wizard
*********************************************************************************

Execute Restore DB Utility from command prompt
 For Windows users : 
  bin>restoreData -c [backup file]
 For Linux users : 
  bin]#sh restoreData.sh -c [backup file]
*********************************************************************************
You chose to open this file: D:\backup_servicedesk_7507_fullbackup_05_26_2009_09_00.data
File name is :  D:\backup_servicedesk_7507_fullbackup_05_26_2009_09_00.data
 requestScheme is http
Please wait extracting backup file
Active DB Server = mssql
Database connectionProp : null
Database started






*************************************************************
  Backpup data  : Tue May 26 09:00:05 AZST 2009
  Database name : servicedesk
  Total Tables  : 851
  DB - Server  : mysql
  Build Number  : 7507
*************************************************************





 
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================


Please wait ! Restoring in Progress...................
0-----------------------50------------------------100(%)
==================QUERY = INSERT INTO holidaydefinition (HOLIDAYDEFINITIONID,HOLIDAYDATE,DESCRIPTION,SITEID,ISRECURRING) VALUESnull
Unable to restore database : Data truncation







                  New to ADSelfService Plus?