Solved

SQL 2008 to MySQL script conversion

Posted on 2011-09-16
2
286 Views
Last Modified: 2012-08-14
Hi,

I have a complicated enough MS SQL 2008 database script. I would like to get the script converted to MySQL as I do not understand MS SQL 2008 especially when it comes to identifying secondary tables and foreign keys .. etc.

What is the best way around this?

Any help much appreciated.

Kind regards,
Paul
0
Comment
Question by:plambkin1
2 Comments
 
LVL 3

Assisted Solution

by:hspoulsen
hspoulsen earned 150 total points
ID: 36548825
My sugestion is to try it out.
When things fail, you ask here why it fails, and what it does.
You then use the replies you get to fix the problem and carry onto the next problem.

HIH
Henrik
0
 
LVL 10

Accepted Solution

by:
sqlservr earned 350 total points
ID: 36548922
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question