![]() After import the data "sucessfully", now the table have all rows, but some data still missing. I have unchecked the option to migrate the structure and informed to import just the data from one table (one of those empties). just trying to imagine when you have hundreds of tables how it could be. So, I tried again using the Webyog tool (the free version that only allows to migrate one table by time. I am concerned about the migration of the structures and mainlly with the data, that were not migrated in many cases. Regarding this, up to me, there is no problem because I can migrate manually all these stuffs, even it will give a lot of work writing again. Also, the views, triggers and stored procedures were *not* migrated. ![]() ![]() The original Sybase tables have data and in Mysql it were migrated empty. Maximum length is 28.Īlso, after checking the tables using Mysql client (and also Webyog gui tool) I found that many tables were empty. The identifier that starts with '"' is too long. SELECT "CodigoDoUsuario", "CodigoDaAgenda", "TemPermissaoDeLeitura", "TemPermissaoDeEscrita", "CodigoDoUsuarioQueRegistrou", "DataDoRegistro", "CodigoDoUsuarioUltimaAlteracao", "DataDaUltimaAlteracao" FROM "dbo"."ACESSO_USUARIO_AGENDA"ĮRROR: The following error occured while transfering data from ACESSO_USUARIO_AGENDA ![]() Transfering data from table ACESSO_USUARIO_AGENDA (6/6 rows) SELECT count(*) AS num FROM "dbo"."ACESSO_USUARIO_AGENDA" Getting the number of rows of table ACESSO_USUARIO_AGENDA I was surprising and happy the the Migration Toolkit has so many resources and have "native" support to Sybase then I started the migration.Īfter starting and finished the hole process after checking the results, I found the Migration report log and found that many messages said like: ![]() A Sybase ODBC account was created on Windows 2000 ODBC Administration and is working. The Sybase Client 11.9.2 is installed on the Windows 2000 server and connecting to the Sybase server normally. The Migration Toolkit is installed on a Windows 2000 server and running normally (production). The Mysql and Sybase are installed on a Debian linux and are running normally. I have installed Migration Toolkit 5.0-r3 for Windows to migrate a Sybase SQL Server version 11.9.2 to Mysql version 5.0.4 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |