Jump to content


Photo

Monyog Deploy


  • Please log in to reply
1 reply to this topic

#1 Srikar

Srikar

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 04 February 2012 - 11:28 AM

Friends,
I am new Joining in the company,New to Admin roles but familiar with MYSQL, earlier Developer to me have migrated MS-SQL2008 Database into MYSQL using 2 tools MYSQL Migration tool kit for Data and SQL ways for objects(Stored Procedures...).At first sight i noticed there are several Issues with SQL queries and procedures in Migrated tables.I want to track those issues/errors/performance involved each one of SQL Query in MYSQL.I found MonYog tool is the ideal choice, how can i connect MYSQL table query to Manlog and possible solution. Help me to solve this, i have around 50 tables in one database how much time each one of the table(query) will take to track Errors.
Thanks

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 04 February 2012 - 03:22 PM



You write

1) "Earlier Developer to me have migrated MS-SQL2008 Database into MYSQL using 2 tools MYSQL Migration tool kit for Data and SQL ways for objects(Stored Procedures...)". "MYSQL Migration tool kit* migtration toolkit has been discontinue several years ago. Additionally we cannot comment on it. it is not our tool. SQLyog/SJA will import table data - it will not even attempt to migrate 'stored programs' of any kind.

2) "At first sight i noticed there are several Issues with SQL queries and procedures in Migrated tables". Undoubtedly. SQL syntax is not the same in MS SQL server and MySQL. In particular not for "strored programs". You should expect to spend quite a lot of effort to rewrite Stored Procedures (and Triggers). I don't belive any tool can do it automatically (and I would not trust anyone telling that their tools can).

3) ".I found MonYog tool is the ideal choice, how can i connect MYSQL table query to Manlog (you mena "MONyog" I guess?) and possible solution.". You could use the Query Analyzer to spot performance issues. Did you read the documentation at http://www.webyog.co...ntroduction.htm (and its subpages) ?





Computers make your grey hair come off ....

Peter Laursen
Webyog




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users