I want to update my localdb with my DASP database. Can I just ftp it to my local App_Data folder directly?
We do not support SQL Express and LocalDB editions of SQL Server in our production environment. To make your LocalDB work on your hosting, you will need to do the following: * Order SQL Server 2012 database addon for your hosting account if you have not done so yet. Please note that LocalDB database cannot be restored to previous versions of SQL Server. * In your local evironment, connect to your LocalDB with MS Management Studio. When connecting, in the "Connect to Server" dialog, in the "Server name" field type "(localdb)\v11.0" without quotes. * Backup your localdb database to a backup file with .BAK extension * Transfer your backup file to your site * Restore the backup to your SQL Server 2012 database using SQL Tools in your DiscountASP.NET hosting control panel.
@Dmitri I'm going the other way. I'm trying to update the 2012 localdb on my laptop with my hosted 2008r2 database. I'm wondering if I can download the hosted database in the App_Data folder directly into my local App_Data folder or do I need to do a backup, download, and restore.
You will not be able to restore SQL Server 2008 R2 standard to localdb or express version of sql server. You will need standard, web, enterprise, or developer version of sql server database in your local environment (2008 R2 or 2012) to be able to restore it.
