3 Replies - 590 Views - Last Post: 30 March 2017 - 04:06 PM Rate Topic: -----

#1 mager1794  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 153
  • Joined: 23-March 09

Best Method to migrate stored procs

Posted 29 March 2017 - 08:23 PM

Are there any efficient methods of migrating stored procs from Sql Server to mySql and vice versa?

Or is this something that unfortunately has to be done manually.
Is This A Good Question/Topic? 0
  • +

Replies To: Best Method to migrate stored procs

#2 Dormilich  Icon User is offline

  • 痛覚残留
  • member icon

Reputation: 4136
  • View blog
  • Posts: 13,056
  • Joined: 08-June 10

Re: Best Method to migrate stored procs

Posted 30 March 2017 - 12:41 AM

that should be possible with sql import/export functions. the question remains whether the SQL used in the MSSQL procedure would also work in MySQL.
Was This Post Helpful? 0
  • +
  • -

#3 astonecipher  Icon User is offline

  • Too busy for this
  • member icon

Reputation: 2330
  • View blog
  • Posts: 9,381
  • Joined: 03-December 12

Re: Best Method to migrate stored procs

Posted 30 March 2017 - 03:36 PM

In my experience, no and if you can find a tool that does it, make sure you thoroughly test it. Migrating tables is far easier.
Was This Post Helpful? 0
  • +
  • -

#4 mager1794  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 153
  • Joined: 23-March 09

Re: Best Method to migrate stored procs

Posted 30 March 2017 - 04:06 PM

View Postastonecipher, on 30 March 2017 - 04:36 PM, said:

In my experience, no and if you can find a tool that does it, make sure you thoroughly test it. Migrating tables is far easier.


Thats the same experience that I was having as well, but I had to atleast ask in case I was missing something.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1