473,698 Members | 2,393 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

migration from sqlserver to MySql

3 New Member
i have done migration of databases from SqlServer to MySql using MySql workbench tool. But using this tool I can't migrate Trigger or Stored procedure...
can anyone give suggestion how to migrate stored procedure or Trigger also?
Apr 4 '14 #1
2 2450
AlexKirpichny
1 New Member
I can suggest the Ispirer software, you may be able to migrate triggers and stored procedures from SQL Server to MySQL using the free demo of the toolkit.
4 Weeks Ago #2
Percepticon77
4 New Member
Migrating stored procedures and triggers from SQL Server to MySQL isn't simple. Different syntax and functions mean it's mostly a manual process.

Start by carefully reviewing your SQL Server code and documenting everything. Use SQL Server Management Studio (SSMS) to generate scripts for your procedures and triggers.

Then, get ready to translate those T-SQL commands into MySQL's procedural SQL. Watch out for SQL Server-specific functions and find MySQL alternatives or workarounds. For example,

Change data types (NVARCHAR to VARCHAR, etc.)
Replace functions (GETDATE() to NOW()).

Don't forget thorough testing in your MySQL environment! Make sure everything runs smoothly and gives you the expected results. You might need to optimize the code a bit since execution plans can differ between the two.
4 Weeks Ago #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
2587
by: Mike Henley | last post by:
considering the recent changes to the mysql licensing terms, which meant the php5 team had to adopt sqlite instead into the php5 and drop mysql stuff from the standard language distro (as i understand things)... will there be a mass migration now to something like postgresql?
0
1735
by: owardman | last post by:
Dear All. Informix 9.3 Solaris 9 MySQL 4.1.10 Linux I am trying to migrate blob data from Informix to MySQL. Has anybody managed this successfully and if so how? Thanks in advance
7
33408
by: phillip.s.powell | last post by:
We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I need to know else (e.g. Navicat)? Thanks Phil
9
2305
by: laredotornado | last post by:
Hello, I am tasked with converting an MsAccess db to a MySQL 4 db in a Linux environment. Can anyone recommend any good freeware/scripts to help me do this? Thanks, - Dave
1
1704
by: shrini | last post by:
Friends. I want to migrate from mysql to postgresql. I have a lot of databases and tables in mysql. I can export them. I need your guidance for importing the databases into postgresql.
3
1568
by: Simone | last post by:
Hi, I have to convert an MySQL database into a ms-sqlserver database. Anyone know a software (is is possible freeware or not so expensive) to translate database? I have only to translate tables, no triggers or stored procedures. Or anyone can send me a link to a web site about this problem? Tank you and escuse for my terrible english! Simone (form Italy)
2
1686
by: =?Utf-8?B?SmVmZnJleQ==?= | last post by:
I have some old ASP programs w/ SQLserver 2000 databases. Now I am developing ASP.NET projects using VB 2005 and SQLserver 2005. What are the best procedures to develop and test the ASP.NET programs? My main concerns are: 1. What do I need to test? VB 2005/ASP.NET with 2000 data? Migration of 2000 data to SQLserver 2005? VB 2005/ASP.NET with 2005 data? 2. How to minimize the transition time? What is the critical change for the...
1
1588
by: Christian Welzel | last post by:
Hi there, i currently evaluating db2 express-c and therefor i wanted to migrate my current database from mysql5 to the express-c... i didn't get it working with mysqldump, and finally found the ibm data migration toolkit. But whenever i want to start the conversation i get this exception: Sun Mar 23 23:07:28 CET 2008 ERROR MySQL TRANSLATOR Translator Internal Exception java.lang.NullPointerException at...
1
9577
ssnaik84
by: ssnaik84 | last post by:
Hi Guys, Last year I got a chance to work with R&D team, which was working on DB scripts conversion.. Though there is migration tool available, it converts only tables and constraints.. Rest of things (stored procedures, functions).. we have to manually edit. That time, we face some interesting challenges.. I failed to document all of them, but whatever I can share with u.. I will try.. :) ...
0
8608
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9161
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8867
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7732
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6522
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4370
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2332
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2006
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.