This should work for going back to a 2005 version as well. "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. SyncBackPro, SyncBackSE and SyncBackFree work on Windows (11, 10, 8, 7, Vista - 32/64-bit), and are used by individuals, small businesses, and organizations throughout the world. The SyncBack family of products backup, synchronize, and restore data files. 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. Compare SyncBackPro, SyncBackSE and SyncBackFree. "Generate scripts" in the wizard, select the entire database and objects in first step. Robocopy is described as or 'Robust File Copy', is a command-line directory replication command.It has been available as part of the Windows Resource Kit starting with Windows NT 4.0, and was introduced as a standard feature of Windows Vista, Windows 7 and Windows Server 2008 and is a File Copy utility in the backup & sync category. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |