Software Engineering Stack Exchange is a question and answer site for professionals, academics, and students working within the systems development life cycle. It only takes a minute to sign up.
Sign up to join this community
The company i'm working for is selling HRIS management software. It was built using ASP and mysql. But one of our client's demand is for it to be based on MS SQL Server. our team is made up mostly of junior programmers / fresh grad and we don't have much experience working in sql server and migrating from one db to another.
Can Mysql stored procedures be migrated to sql server using 'SQL Server Migration Assistant'?
If so, how?
If no, what other options do we have?
I'm fairly new to the SQL world as well. Don't let these guys get to you, they are ruthless sometimes (I'm getting a down vote for that!). Gnat is right though when it comes to your issue being a very Large Project. You had better believe that that is by design. Each company wants things done there own way and don't really like the idea of cross-platform. However, you will notice that almost all of them have developed a way to get databases from other platforms to migrate to their own (imagine that). Microsoft is no exception.
Microsoft SQL Server Migration Assistant v5.3 for MySQL
As you suggested, do a quick google search for the software above. It is free. It probably still wont be easy. Especially the stored procedures and the like. Microsoft does have some documentation on how to use it. Hope this helps.
