![]() 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. 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. From the Restrict Access option, select Single. ![]() In the Database Properties dialog box, click the Options page. Right-click the database to change, and then click Properties. 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". In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |