What is the best procedure. I am a little worried that if I do a restore from a 2008 backup it will still be effectively a 2008 sql server database and not have access to all the 2012 features. Thanks, Will
Need to crack on. I have created a new sql server 2012 DB on my local sql server instance. Copied data from old 2008 DB to new 2012 DB. Will then do a restore. Still interested to know if this is the best way?
Now Decided to Use the Toolsuite to Move DBs I have now decided to use the online sql server toolsuite to create a db .bak backup from the 2008 SQL Server and then restore to the new 2012 SQL Server as it was taking an age using the SQL Management Studio data migration tool. My Question Are there any downsides to doing this? And per my original post will the DB on the 2012 SQL Server be in the 2012 'format'? Hope that all makes sense? Will
You should be able to perform a restore of a SQL Server 2008 database to a 2012 server instance without any problems.
Hey Will1968, I don't see any down side to upgrading to a SQL 2012 database. The fastest and easiest way to migrate from our hosted SQL 2008 to our hosted SQL 2012 is by creating a backup of the SQL 2008 using our Backup Tool in the control panel. This will create the .bak file on your web site file system and place it in the _database directory. Then use the Restore tool on the SQL 2012 database to restore .bak file you just created on the SQL 2008 database to the SQL 2012 database. Side note: You wont be able to restore a SQL 2012 to a SQL 2008 database. You can only restore a old version to a newer version of SQL database.
i have included another post from our forum which provides basic instructions from upgrading from SQL 2005 to SQL 2008, but it should all be the same for 2008 to 2012 except for the client link. http://community.discountasp.net/showthread.php?t=6512
Followed your instructions and it all worked. The only thing I seemed to have to do was recreate my Users to get the access privileges I had before. Not sure why. Many thanks, Will
When you created/ordered the new DB you would still need to create the users if you were using them before. I don't believe the backup tool will save the user settings for the old DB.
Do you mean the Login accounts that get set via the DASP website Control Panel? I did recreate these but in addition it seems I also needed to recreate the SQL Server Users (using SSMS) even though they were still there. Small thing but initially I was slightly stumped as to what the problem was. Will
