Navision 4.0 deployment to Windows Azure

Answer 1

Hello.

1) If I take the backup of MS SQL Database, how can I restore it to AZURE?

No way of doing so. Refer to answer to your second question below.

2) AM I needed to convert the MS SQL Data to SQL Azure, if yes please let me know the process of that?

Yes, you need. Check this link: http://msdn.microsoft.com/en-us/library/windowsazure/ee730904.aspx Simply you need to use SQL Server Management Studio 2008 R2 and use its built-in functionality Import/Export or Generate Script (don't forget to check compatibility with Azure if you will use this method). Be aware - there are some differences between SQL Server and SQL Azure. You can use SQL Azure Migration Wizard - it can detect functionality in your local db that is not supported by SQL Azure and say you about it.

3) If it gets converted how will it be converted back to SQL server database as Navision client can only understand SQL server database not SQL Azure Database

As i say above, you can use SSMS. If you will export your db to sql azure you will have the _same_ db and it will be fully supported by Navision (because SQL Azure is, roughly, just a cloud SQL Server).

4) Can we directly store or import the SQL database to windows Azure?

SSMS or you can connect to your SQL Server and run an TSQL query for restore your db scheme/data.

5) If we can store SQL Data directly than what server name we need to mention to our Navision Client, Navision client is not web based.

In this situation please check materials about Windows Azure Connect.

Answer 2

 

The response is very satisfactory.Iwill try all the above.

Thanks

---

Thanks Anju Sardana

Answer 3

Please ask if you will have any questions or problems.

Answer 4

 

Honestly I am worried about the last step , 5) If we can store SQL Data directly than what server name we need to mention to our Navision Client, Navision client is not web based.

 

Reason Navision only accept SQL SERVER DTABASE NAME.

---

Thanks Anju Sardana

Answer 5

Hi,

Perhaps your can use SQL Azure database, the no web based client can also access the SQL database normally.

http://www.windowsazure.com/en-us/develop/net/how-to-guides/sql-azure/

Hope it can help you.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework

Answer 6

Hello.

As Arwind said, yes, you can use SQL Azure as SQL Server. SQL Azure server has canonical name that you can use in your connection strings. Nothing is changed logically - you still use some server name, but instead of SQL Server you use cloud server.