![]() ![]() It can also back up databases to an FTP server - or a folder on your local machine, network server, or storage device. ![]() This should work for going back to a 2005 version as well. SQL Backup Master backs up your SQL Server databases to any number of popular cloud storage services such as Dropbox, OneDrive, Amazon S3, Microsoft Azure, Box, and Google Drive. "Copy data from one or more tables or views", select the top checkbox to select all tables and then next step, run the package and you should have everything on a older version. "Import Data." choose source as the R2 database and the destination as the new database. sql script and execute and you should see the new database.ģ) Now right click on the new database and select "Tasks". This is a crucial step, because "import data" by itself does not bring along all the primary keys, constriants and any other objects like stored procedures."Ģ) Run the SQL script generated on the new install or database instance SQL Express or SQL Server 2008 using the query window or open saved. On the "Set Scripting Options" step you should see a button "Advanced", select this and make sure you select "Script for Server Version" = SQL Server 2008" not R2 version. "Generate scripts" in the wizard, select the entire database and objects in first step. It's not pretty, but this is how I did it granted you have this option installed on your SQL 2008 R2 install.ġ) Right click database in SQL Server 2008 R2 "Tasks". ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |