Since you don't need to transfer any data you might want to consider just hacking the mysqldump SQL code (good old Find & Replace.) to the point where SQL Server will execute it. I just had to write some T-SQL to re-create the indexes and whatnot. This actually is a model to shape your career as per Cognizant needs. Next is the CCA which is the Cognizant Career Architecture. It comprises of a few certificates that you achieve once you pass these exams. Still, it did transfer the tables and data, which was my main objective. It is a combination of a sequence of internal exams that you need to pass over a fixed period of time. However, even that was an incomplete solution because the transfer from MySQL to Access omitted all of the primary keys, indexes, and AUTO_INCREMENT attributes. mdb file (!) via MySQL ODBC, then import that into SQL Server. The only method that didn't fail outright was to pull the tables from MySQL into a Microsoft Access. Using MySQL ODBC and the SQL Server Import and Export Wizard: The wizard crashed (i.e., the Windows " has stopped working." error) when trying to access the MySQL database. Using MySQL Workbench: I could not find a way to migrate a database from MySQL to SQL Server. Using HeidiSQL to export the MySQL database directly to SQL Server: HeidiSQL also generated SQL statements that SQL Server would not accept. Using phpMyAdmin to Export the table definitions with "MSSQL" compatibility: The resulting SQL script would not execute in SQL Server Management Studio (SSMS) due to syntax errors. I recently had to do essentially the same thing, except that I wanted to migrate MySQL tables and data to SQL Server.
0 Comments
Leave a Reply. |