forums › forums › SQLyog › SQLyog BETA Discussions › 5.16 Beta 9 – Migration Toolkit
- This topic is empty.
-
AuthorPosts
-
-
July 21, 2006 at 2:05 pm #9766
intel352
MemberOkay, I am trying to do a fresh import from tables on my local MS SQL server, to my remote MySQL webserver. I'm using 5.16 beta 9
Just for some background, I've been using SQLYog for a few weeks to successfully import from local to remote, with very few issues showing up. I already have a job created from previous version of SQLYog. The job is designed to dump & recreate the SQL tables, and import all rows.
This morning, I installed Beta 9 to fix an issue that I was having with version 5.15 (the issue that occurs where you open an existing job file, and no tables are selected). In Beta 9, I open the existing job, all tables are selected appropriately. I ensured all tables are set to MyISAM, and proceed with the import procedure. I then encounter these errors:
Quote:Job started at Fri Jul 21 09:44:06 2006DBMS Information: MICROSOFT SQL SERVER
Importing table schema: product_upc… Successful…
Importing table schema: product_line… Successful…
Importing table schema: person… Successful…
Importing table schema: product…
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unlocked, `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL ' at line 1
Table:tblProduct
Sql:CREATE TABLE `soundch_repo`.`product`( `ProductID` int(10) UNSIGNED NOT NULL , `ProductType` varchar(50) NULL , `ProductName` varchar(255) NULL , `Company` varchar(50) NULL , `StockID` varchar(50) NULL , `LookupAs` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Unlocked, `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) UNSIGNED NOT NULL DEFAULT 1, `Inactive` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `Deleted` smallint(5) NOT NULL DEFAULT 0, `QtyOnHand` int(10) NULL DEFAULT 0, `MinOrder` int(10) NULL DEFAULT 1, `LotSize` int(10) NULL DEFAULT 1, `AcctPartID` varchar(50) NULL , `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `LineID` varchar(100) NULL , `SubLineID` varchar(100) NULL , `ProductImage` varchar(255) NULL , `SongSample` varchar(255) NULL , `ProductCategory` int(10) NULL , `Terms` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `CustProductCode` varchar(50) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `iTemporary` int(10) NULL DEFAULT 0, `NotForSellOnWeb` int(10) NULL DEFAULT 0, `Artwork` varchar(50) NULL , PRIMARY KEY ( `ProductID` ) , UNIQUE KEY `aaaaatblProduct2_PK` (`ProductID` ASC ),KEY `AcctPartID` (`AcctPartID` ASC ),KEY `Deleted` (`Deleted` ASC ),KEY `Format` (`Format` ASC ),KEY `Genre` (`Genre` ASC ),KEY `Inactive` (`Inactive` ASC ),KEY `IX_tblProduct_iTemporary` (`iTemporary` ASC ),KEY `IX_tblProduct_NotForSellOnWeb` (`NotForSellOnWeb` ASC ),KEY `IX_tblProduct_SendToWeb` (`SendToWeb` ASC ),KEY `LineID` (`LineID` ASC ),KEY `LookupAs` (`LookupAs` ASC ),KEY `ProductName` (`ProductName` ASC ),KEY `ProductType` (`ProductType` ASC ),KEY `ReleaseDate` (`ReleaseDate` ASC ),KEY `SellOffDate` (`SellOffDate` ASC ),KEY `Status` (`Status` ASC ),KEY `TermDate` (`TermDate` ASC ) )Engine=MyISAM
Check C:Program FilesSQLyog Enterprisesja_initial_import.log for complete error details.
Importing table schema: product_license…
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `Se' at line 1
Table:tblProductLicense
Sql:CREATE TABLE `soundch_repo`.`product_license`( `ProductLicenseID` int(10) UNSIGNED NOT NULL , `ProductSongID` int(10) UNSIGNED NULL , `Region` varchar(255) NULL , `LicenseType` varchar(10) NULL , `PersonID` int(10) NULL , `InCareOfID` int(10) UNSIGNED NULL , `Accept` smallint(5) NULL DEFAULT -1, `Rate` decimal(19,4) NULL , `Multiplier` int(10) NULL DEFAULT 1, `AdminFee` decimal(19,4) NULL DEFAULT 0, `Advance` decimal(19,4) NULL , `AdvanceQty` float UNSIGNED NULL , `Terms` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `Status` varchar(50) NULL DEFAULT Pending, `LicenseNum` varchar(50) NULL , `PercentOwned` float NULL , `OriginalAdvance` decimal(19,4) NULL , `ExecuteDate` timestamp(23) NULL , `ExecuteBy` varchar(50) NULL , `ChangeUser` varchar(50) NULL , `ChangeDate` timestamp(23) NULL , PRIMARY KEY ( `ProductLicenseID` ) , UNIQUE KEY `PK_tblProductLicenseRestore$` (`ProductLicenseID` ASC ) )Engine=MyISAM
Check C:Program FilesSQLyog Enterprisesja_initial_import.log for complete error details.
Importing table schema: product_link… Successful…
Importing table schema: product_song… Successful…
Importing table schema: song…
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unlocked, `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(' at line 1
Table:tblSong
Sql:CREATE TABLE `soundch_repo`.`song`( `SongID` int(10) UNSIGNED NOT NULL , `SCSongNum` varchar(50) NULL , `SongName` varchar(80) NULL , `LookupAs` varchar(255) NULL , `CatalogName` varchar(255) NULL , `ID4D` int(10) UNSIGNED NULL , `Artist` varchar(80) NULL , `ArtistCatalog` varchar(255) NULL , `Writer` varchar(255) NULL , `Publisher` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Unlocked, `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) NOT NULL DEFAULT -1, `Inactive` smallint(5) NOT NULL DEFAULT 0, `Deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `LibrarySongID` int(10) NULL , `ParentalAdvisory` int(10) NULL DEFAULT 0, `RestrictedOnInternet` int(10) NULL DEFAULT 0, `SongSample` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `YearReleased` int(10) NULL , `MovieShowTitle` varchar(50) NULL , `Category` varchar(50) NULL , `NoCatalog` int(10) NULL , `A_Mix_On_Server` bit(1) NULL , `B_Mix_On_Server` bit(1) NULL , `C_Mix_On_Server` bit(1) NULL , `D_Mix_On_Server` bit(1) NULL , `Stereo_Mix_Ringtone_On_Server` bit(1) NULL , `Music_Mix_Ringtone_On_Server` bit(1) NULL , `BackgroundVocal` varchar(1) NULL , `KeyChanges` varchar(80) NULL , `MasterNum` int(10) NULL , `StereoVolume` int(10) NULL , `Tempo` int(10) NULL , `SongTime` varchar(20) NULL , `Date_Mixed` varchar(20) NULL , `SongKey` varchar(3) NULL , `PickDate` timestamp(23) NULL , `CDGCustomAvailable` varchar(50) NULL , PRIMARY KEY ( `SongID` ) , UNIQUE KEY `PK_tblSong` (`SongID` ASC ),KEY `IX_tblSong_Artist` (`Artist` ASC ),KEY `IX_tblSong_Deleted` (`Deleted` ASC ),KEY `IX_tblSong_Format` (`Format` ASC ),KEY `IX_tblSong_Genre` (`Genre` ASC ),KEY `IX_tblSong_ID4D` (`ID4D` ASC ),KEY `IX_tblSong_Inactive` (`Inactive` ASC ),KEY `IX_tblSong_LibrarySongID` (`LibrarySongID` ASC ),KEY `IX_tblSong_LookupAs` (`LookupAs` ASC ),KEY `IX_tblSong_MovieShowTitle` (`MovieShowTitle` ASC ),KEY `IX_tblSong_ParentalAdvisory` (`ParentalAdvisory` ASC ),KEY `IX_tblSong_RestrictedOnInternet` (`RestrictedOnInternet` ASC ),KEY `IX_tblSong_SCSongNum` (`SCSongNum` ASC ),KEY `IX_tblSong_SendToWeb` (`SendToWeb` ASC ),KEY `IX_tblSong_SongName` (`SongName` ASC ),KEY `IX_tblSong_Status` (`Status` ASC ) )Engine=MyISAM
Check C:Program FilesSQLyog Enterprisesja_initial_import.log for complete error details.
Importing table schema: song_engineering… Successful…
Importing table schema: song_relationship…
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Pending, `PubSongNum` varchar(50) NULL , PRIMARY KEY ( `SongRelationshipID` ) ,' at line 1
Table:tblSongRelationship
Sql:CREATE TABLE `soundch_repo`.`song_relationship`( `SongRelationshipID` int(10) UNSIGNED NOT NULL , `SongID` int(10) UNSIGNED NOT NULL , `PersonID` int(10) UNSIGNED NOT NULL , `DisplayName` varchar(255) NULL , `RelationshipType` varchar(50) NULL , `PercentOwned` float UNSIGNED NULL , `Limits` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT Pending, `PubSongNum` varchar(50) NULL , PRIMARY KEY ( `SongRelationshipID` ) , UNIQUE KEY `PK_tblProductRelationship` (`SongRelationshipID` ASC ),KEY `IX_tblSongRelationship_DisplayName` (`DisplayName` ASC ),KEY `IX_tblSongRelationship_PersonID` (`PersonID` ASC ),KEY `IX_tblSongRelationship_RelationshipType` (`RelationshipType` ASC ),KEY `IX_tblSongRelationship_SongID` (`SongID` ASC ),KEY `Status` (`Status` ASC ) )Engine=MyISAM
Check C:Program FilesSQLyog Enterprisesja_initial_import.log for complete error details.
Importing table data: product_upc…
At this point, I Terminate the process, since the errors should not be there. I close the wizard, Open the wizard, create a brand new job file, performing the same tasks. I don't change any settings per-table other than specifying MyISAM.
I begin the import process, and again encounter errors:
Quote:SQLyog Job Agent Version 5.16Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.
Job started at Fri Jul 21 09:51:24 2006
DBMS Information: MICROSOFT SQL SERVER
Importing table schema: product_upc… Successful…
Importing table schema: product_line… Successful…
Importing table schema: person… Successful…
Importing table schema: product…
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEF' at line 1
Table:tblProduct
Sql:CREATE TABLE `soundch_repo`.`product`( `ProductID` int(10) UNSIGNED NOT NULL , `ProductType` varchar(50) NULL , `ProductName` varchar(255) NULL , `Company` varchar(50) NULL , `StockID` varchar(50) NULL , `LookupAs` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT 'Unlocked', `LockStatus` int(10) NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) UNSIGNED NOT NULL DEFAULT 1, `Inactive` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `Deleted` smallint(5) NOT NULL DEFAULT 0, `QtyOnHand` int(10) NULL DEFAULT 0, `MinOrder` int(10) NULL DEFAULT 1, `LotSize` int(10) NULL DEFAULT 1, `AcctPartID` varchar(50) NULL , `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `LineID` varchar(100) NULL , `SubLineID` varchar(100) NULL , `ProductImage` varchar(255) NULL , `SongSample` varchar(255) NULL , `ProductCategory` int(10) NULL , `Terms` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `CustProductCode` varchar(50) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `iTemporary` int(10) NULL DEFAULT 0, `NotForSellOnWeb` int(10) NULL DEFAULT 0, `Artwork` varchar(50) NULL , PRIMARY KEY ( `ProductID` ) , UNIQUE KEY `aaaaatblProduct2_PK` (`ProductID` ASC ),KEY `AcctPartID` (`AcctPartID` ASC ),KEY `Deleted` (`Deleted` ASC ),KEY `Format` (`Format` ASC ),KEY `Genre` (`Genre` ASC ),KEY `Inactive` (`Inactive` ASC ),KEY `IX_tblProduct_iTemporary` (`iTemporary` ASC ),KEY `IX_tblProduct_NotForSellOnWeb` (`NotForSellOnWeb` ASC ),KEY `IX_tblProduct_SendToWeb` (`SendToWeb` ASC ),KEY `LineID` (`LineID` ASC ),KEY `LookupAs` (`LookupAs` ASC ),KEY `ProductName` (`ProductName` ASC ),KEY `ProductType` (`ProductType` ASC ),KEY `ReleaseDate` (`ReleaseDate` ASC ),KEY `SellOffDate` (`SellOffDate` ASC ),KEY `Status` (`Status` ASC ),KEY `TermDate` (`TermDate` ASC ) )Engine=MyISAM
Check C:Program FilesSQLyog Enterprisesja_initial_import.log for complete error details.
Importing table schema: product_license…
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `Se' at line 1
Table:tblProductLicense
Sql:CREATE TABLE `soundch_repo`.`product_license`( `ProductLicenseID` int(10) UNSIGNED NOT NULL , `ProductSongID` int(10) UNSIGNED NULL , `Region` varchar(255) NULL , `LicenseType` varchar(10) NULL , `PersonID` int(10) NULL , `InCareOfID` int(10) UNSIGNED NULL , `Accept` smallint(5) NULL DEFAULT -1, `Rate` decimal(19,4) NULL , `Multiplier` int(10) NULL DEFAULT 1, `AdminFee` decimal(19,4) NULL DEFAULT 0, `Advance` decimal(19,4) NULL , `AdvanceQty` float UNSIGNED NULL , `Terms` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `StartDate` timestamp(23) NULL , `EndDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `Status` varchar(50) NULL DEFAULT 'Pending', `LicenseNum` varchar(50) NULL , `PercentOwned` float NULL , `OriginalAdvance` decimal(19,4) NULL , `ExecuteDate` timestamp(23) NULL , `ExecuteBy` varchar(50) NULL , `ChangeUser` varchar(50) NULL , `ChangeDate` timestamp(23) NULL , PRIMARY KEY ( `ProductLicenseID` ) , UNIQUE KEY `PK_tblProductLicenseRestore$` (`ProductLicenseID` ASC ) )Engine=MyISAM
Check C:Program FilesSQLyog Enterprisesja_initial_import.log for complete error details.
Importing table schema: product_link… Successful…
Importing table schema: product_song… Successful…
Importing table schema: song…
ERROR: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEF' at line 1
Table:tblSong
Sql:CREATE TABLE `soundch_repo`.`song`( `SongID` int(10) UNSIGNED NOT NULL , `SCSongNum` varchar(50) NULL , `SongName` varchar(80) NULL , `LookupAs` varchar(255) NULL , `CatalogName` varchar(255) NULL , `ID4D` int(10) UNSIGNED NULL , `Artist` varchar(80) NULL , `ArtistCatalog` varchar(255) NULL , `Writer` varchar(255) NULL , `Publisher` varchar(255) NULL , `Status` varchar(50) NULL DEFAULT 'Unlocked', `LockStatus` int(10) UNSIGNED NULL DEFAULT 0, `Description` varchar(50) NULL , `Note` varchar(255) NULL , `Price` decimal(19,4) NULL DEFAULT 0, `Frequent` smallint(5) NOT NULL DEFAULT -1, `Inactive` smallint(5) NOT NULL DEFAULT 0, `Deleted` smallint(5) UNSIGNED NOT NULL DEFAULT 0, `PopupNote` varchar(255) NULL , `Genre` varchar(50) NULL , `SubGenre` varchar(50) NULL , `Format` varchar(50) NULL , `ReleaseDate` timestamp(23) NULL , `TermDate` timestamp(23) NULL , `SellOffDate` timestamp(23) NULL , `ConvertedID` varchar(50) NULL , `ConvertedTable` varchar(50) NULL , `CreateDate` timestamp(23) NULL DEFAULT getdate(), `CreateUser` varchar(50) NULL , `UpdateDate` timestamp(23) NULL DEFAULT getdate(), `UpdateUser` varchar(50) NULL , `LibrarySongID` int(10) NULL , `ParentalAdvisory` int(10) NULL DEFAULT 0, `RestrictedOnInternet` int(10) NULL DEFAULT 0, `SongSample` varchar(50) NULL , `SendToWeb` int(10) NULL DEFAULT -1, `YearReleased` int(10) NULL , `MovieShowTitle` varchar(50) NULL , `Category` varchar(50) NULL , `NoCatalog` int(10) NULL , `A_Mix_On_Server` bit(1) NULL , `B_Mix_On_Server` bit(1) NULL , `C_Mix_On_Server` bit(1) NULL , `D_Mix_On_Server` bit(1) NULL , `Stereo_Mix_Ringtone_On_Server` bit(1) NULL , `Music_Mix_Ringtone_On_Server` bit(1) NULL , `BackgroundVocal` varchar(1) NULL , `KeyChanges` varchar(80) NULL , `MasterNum` int(10) NULL , `StereoVolume` int(10) NULL , `Tempo` int(10) NULL , `SongTime` varchar(20) NULL , `Date_Mixed` varchar(20) NULL , `SongKey` varchar(3) NULL , `PickDate` timestamp(23) NULL , `CDGCustomAvailable` varchar(50) NULL , PRIMARY KEY ( `SongID` ) , UNIQUE KEY `PK_tblSong` (`SongID` ASC ),KEY `IX_tblSong_Artist` (`Artist` ASC ),KEY `IX_tblSong_Deleted` (`Deleted` ASC ),KEY `IX_tblSong_Format` (`Format` ASC ),KEY `IX_tblSong_Genre` (`Genre` ASC ),KEY `IX_tblSong_ID4D` (`ID4D` ASC ),KEY `IX_tblSong_Inactive` (`Inactive` ASC ),KEY `IX_tblSong_LibrarySongID` (`LibrarySongID` ASC ),KEY `IX_tblSong_LookupAs` (`LookupAs` ASC ),KEY `IX_tblSong_MovieShowTitle` (`MovieShowTitle` ASC ),KEY `IX_tblSong_ParentalAdvisory` (`ParentalAdvisory` ASC ),KEY `IX_tblSong_RestrictedOnInternet` (`RestrictedOnInternet` ASC ),KEY `IX_tblSong_SCSongNum` (`SCSongNum` ASC ),KEY `IX_tblSong_SendToWeb` (`SendToWeb` ASC ),KEY `IX_tblSong_SongName` (`SongName` ASC ),KEY `IX_tblSong_Status` (`Status` ASC ) )Engine=MyISAM
Check C:Program FilesSQLyog Enterprisesja_initial_import.log for complete error details.
Importing table schema: song_engineering… Successful…
Importing table schema: song_relationship… Successful…
Importing table foreign keys: product_line… Successful…
Importing table data: product_upc…
I terminate again, and created this thread…
Any help would be great. Thanks
-
July 21, 2006 at 2:38 pm #21992
peterlaursen
ParticipantActually the problem that you have with beta9 is becauase we SOLVED it.
Believe it or not!
it is 'DEFAULT getdate()' that is the problem. getdate() is not available in MySQL. From the Map option you can enter the MySQL equivalent “now()” or “CURRENT_TIMESTAMP” (they are synonyms).
Before beta 9 SJA/Migration 'quoted' DEFAULTs. Beta9 does not and you can enter KEYWORDS and FUNCTIONS that MySQL accepts as DEFAULTs.
Before beta9 there was no way. Any quoted 'string' would raise an error with MySQL Timestamps.
Some day in the future we may build in the program some small 'conversion tables' for converting from SQL server, Oracle, Sybase etc. But we actually had a user in our ticket system yesterday that needed a usable fix IMMEDIATELY.
-
July 21, 2006 at 2:41 pm #21993Member
okay, thanks for the info. does it seem to you that “getdate()” is the only function that needs to be converted? (according to the error logs?)
-
July 21, 2006 at 2:50 pm #21994Participant
I actually I think so!
The MySQL parser is not very 'precise' in spotting the exact place. That is due to caching, code optimizing etc (actually a lot of code gets rewritten by the MySQL optimizer). It is common that the syntax error is 20-50 characters before the parser says 'stop. I had enough'! And I have seen it much before that.
Is is not syntax debugging comparable to a compiler/IDE!
And as far as I can see there are getdate()'s not so far from/before the error message. 'not so far' in MySQL parser terms.
-
July 21, 2006 at 3:04 pm #21995Participant
Two more details:
1) Note that there can only be one column defined as 'default CURRENT_TIMESTAMP' in a MySQL table. If you try to insert more now()'s or CURRENT_TIMESTAMP's as defaults only the first will be effective. The next(s) will silently be converted to 'default 0000-00_00 00:00:00' (at least hat was what happened to me when I tsted this with Acces yesterday)
2) If you wnat to use the TIMESTAMP defined as
'default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP' you will have to execute the appropriate SQL statement (ALTER TABLE) after the import. You can do from a 'Notifications Service' job running in the same batch as the Migration. SJA does not have a monkeyman's chance to know if you will use this clause or not!
See MySQL documentation at:
http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html
When we have checked other ODBC sources (Oracle, Interbase, Sybase etc) for similar issues we will of course document it. Maybe even over time implement code that solves most cases 'automatically'
-
-
AuthorPosts
- You must be logged in to reply to this topic.
