Saturday, January 15, 2011

Easy Database Migration to SQL Azure using SSMA

Hello Fellas up with my new post on SSMA and migration I hope you will like it.

Guys have you ever thought that what will happen if your currently running application is required to deploy on the cloud environment and currently you are having a huge amount of data in your database Or think like you want to deploy a schema on internet to be accessible by user you might be thinking that you need to create a whole new database or you need to copy each and everything again on the new database and bla bla.... :-O .Hold on guys we have a solution for you to get rid of all this messy things...follow the blog below for solution.

The Migration of SQL Server database to SQL Azure is possible so you can directly migrate the schema or the whole database to the SQL Azure using SSMA i.e SQL Server Migration Assistant. By using SSMA you can directly migrate your Database present on SQL Server to the SQL Azure. Now the question comes to the Access database ..

So for Microsft Access database the solution present was to migrate it data to Non Azure SQL server database and then migrating this data to the SQL Azure.But this was very time consuming process but a feasible one.But now there is SSMA available for Microsoft Access i.e SQL Server Migration Assistant for Access which allows you to migrate your data and schema directly from the access to SQL Azure ,as well as SQL Server 2005,2008 and 2008 R2.Just like with SQL Server ,you can use your Access 2010 application as the front-end to your SQL Azure database. Seems Good news na...

For details on migration of your data to SQL Azure contact me

Jayesh Maduskar
Microsoft Student Partner|Adobe Student Reps|OSUM Leader
Opera Campus Crew.
jayesh.maduskar@msptechrep.com

2 comments:

  1. It was really nice and good news for access and sql users to go for cloud based appn and enhance the buisness and soon but such facility or utility is there for oracle users or not?

    ReplyDelete
  2. Yes there is SSMA for Oracle v1.2 for achieving this task for the oracle users.

    ReplyDelete