Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Stored Procedures

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Stored Procedures

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 26, 2009 at 6:25 pm #11560
      Emi
      Member

      Hi.

      I am using SqlYog Enterprise Schema Synchronization tool but I notice that it cannot carry the stored procedures from target to the source when the database user names are different. The SQLs generated to carry the stored procedures include the db user name as well, which creates the problem. Is there an option or a way to overcome this problem? I can copy the sql, replace the dbusername and run it, but I would like to automate the process. And the grid hosting environment we are using does not allow having the same db user names on different databases.

      Thanks for your help

    • June 26, 2009 at 6:35 pm #29215
      peterlaursen
      Participant

      You will have to edit the script generated. If 'definer' or 'sql security' is defined differently Schema Sync will find difference and there is currently no option to ignore this.

      We have already this recorded here: http://code.google.com/p/sqlyog/issues/detail?id=32

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.