Hi Madusanka/ Dhanuka,
Thanks for your responses.
@Madusanka, The SSMA tool you mentioned seems to work fine. It seems to
convert the schema properly. Will do some more testing and verify, thanks
a lot for the info.
On Mon, Apr 27, 2015 at 6:38 PM, Madusanka Premaratne madusan...@wso2.com
Hi,
I have come across a situation where I need to migrate my MySQL db to
MSSQL in wso2 api manager. I have so far tried the following.
1) Using the ODBC connector and creating linked databases in MSSQL
In this approach, when importing the database, the schema seems to
change, for e.g. for
I haven't done such thing before but you can try out something like this.
Write some sql scripts which has some select insert statements (select form
mysql insert into mssql). Hope this is not much complex since column names
and table names are equal. You may need to write simple Java program to
Hi Shani,
I used a tool called SQL Server Migration Client. But I did this a few
years back and I think it only works with windows.
Have a look at [1]
[1] - http://blogs.msdn.com/b/ssma/p/mysql.aspx
Thanks,
Madusanka
On Mon, Apr 27, 2015 at 4:44 PM, Dhanuka Ranasinghe dhan...@wso2.com
wrote: