Hi Contact [EMAIL PROTECTED] he has a whitepaper on how to migrate from Oracle Axapta to MS SQL2000 Axapta.
Regards Michael -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David Casas Sent: 30. marts 2006 22:10 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Converting Axapta Oracle DB to MSSQL 2005 using MSSQL Migration Assistant? Hi Helmut, I doing some test with the SSMA. Today I talk with Microsoft people, and they tell me that this software only migrate more or less the 85% of the data correctly!!! :| With this tables I think the solution was export with the axapta tool to a dat / def files. I have one question... how many time do you spent in migrate the database? Regards. David. ----- Original Message ----- From: hwimmer To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, March 28, 2006 4:08 PM Subject: [Axapta-Knowledge-Village] Converting Axapta Oracle DB to MSSQL 2005 using MSSQL Migration Assistant? Hi! I tried to convert our Oracle 9i database to MSSQL2005 using the MS SQL Migration Assistant (SSMA). We are running Axapta 3.0 SP3 and I installed the Kernel rollup. Everything is working except tables that have field names which seem to be keywords. Example: Table "Address" has the field "Type". When trying to migrate the data, the SSMA gives me the error: JDBC Error: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer] Invalid column name '"TYPE"'. Another error message (from another table): JDBC Error: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer] Invalid column name '"NAME"'. Some other tables work quite well, it seems to me it's a problem with the quoted identifiers or the field names or both. Anybody got an idea? Already converted an Axapta Oracle DB with SSMA? Best regards, Helmut http://axaptafreak.blogspot.com BTW: I cannot just export the company data and import again in Axapta, as we are using Virtual Companies and all the recid's will get mixed up, so that's not an option. I also tried SSIS (SQL Server Integration Services) but that also gives me huge amounts of errors. Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools ---------------------------------------------------------------------------- -- YAHOO! GROUPS LINKS a.. Visit your group "Axapta-Knowledge-Village" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ---------------------------------------------------------------------------- -- [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/