Here i am migrating MySql database to Amazon RDS, Steps are the same for every database like SqlServer or oracle etc.. Sometimes [error 87] comes when migrating database tables containing data or records,, So to avoid it migrate empty tables...
Follow steps:
1) In MySql go to migrate option in database option and insert local database details, username = root and password = root if you have these one..
2) Insert target database host name , see in 3rd picture, end point is host name. Copy this from your Amazon console and paste it..
3) Now download RazorSQL , this is used to access remote database,
Download : http://www.razorsql.com/download.html
4) Create a conenction and connect to remote database.
5) Now insert your data into tables or update records..
You are done.. This approach is very handful b'coz sometimes while migrating data parameters are not adjustable and create problems..
Pls do comment on this and like this !
No comments:
Post a Comment