Doubt on Shared Hosting With Asp.net 2.0

Question

User-807418713 posted

Hello

I have website in asp.net 2.0 C# for that website we have used sql 2008 r2 database 

Now we want to host this website online we have checked some hosting provider they are saying they have 2012 or 2016 ms sql 

our doubt is will our website work with sql 2016?

Thanking You

Answer 1

User475983607 posted

See the Microsoft Data Migration Assistant.

https://www.microsoft.com/en-us/download/details.aspx?id=53595

https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017

Answer 2

User1120430333 posted

IMO, you should hire a DBA consultant and migrate from one version of MS SQL Server to a newer version.

Answer 3

User61956409 posted

Hi Gopi.MCA,

Firstly, as others mentioned, you can try to migrate your database by using some migration tools, such as Data Migration Assistant (DMA) that support these source and target versions:

Sources

• SQL Server 2005
• SQL Server 2008
• SQL Server 2008 R2
• SQL Server 2012
• SQL Server 2014
• SQL Server 2016
• SQL Server 2017 on Windows

Targets

• SQL Server 2012
• SQL Server 2014
• SQL Server 2016
• SQL Server 2017 on Windows and Linux
• Azure SQL Database
• Azure SQL Database Managed Instance

Besides, if possible, you can host your website on Azure web app that enable us to connect to on on-premises resources, such as on-premises SQL database, which does not require to migrate your existing database.

With Regards,

Fei Han