Under General set “Target Server” to “SQL Server”.ī. Ĭlick and change the following options:Ī. Server name for my machine is “VAIOE\SQLSERVER2012”, use Windows authentication, select “Master DB (list all databases)” from the database options and “Save Login Information”. Select the Target Server as “SQL Database latest service version (V12)”. ![]() Select the Analyse/Migrate radio button from the right hand side of the main window. Microsoft have now removed SQLAzureMW from Codeplex. To use this package to migrate a databases from SQL Server 20012 to 2008 R2, you can do the following: "Complete the Wizard", click to execute the package and create the "downgraded" database.Īnother method I found was the SQL Database Migration Wizard which was created by Microsoft and which I think (I don't know) that the wizard above was created from. įor this example, select the "Run Immediately" option for "Schedule the Package" options, click. Ĭonfigure the integration services package, click. Select the required option for if the database exists. Ĭonfigure the destination database path and logical names etc. Select to move or copy the required databases, click. ![]() "Select the Transfer Method" For the sake of this example, select "Use the SQL Management Object method", click. ![]() ![]() "Select a Destination Server:" Set the "Destination server" as the 2008 R2 (or lower version instance), and set the appropriate authentication. "Select a Source Server": Set the "Source server" as the 2012 instance (or the higher version server instance), and set the appropriate authentication. "Welcome to the Copy Database Wizard" click. In the 2012 instance, right click on the database you want to copy/"downgrade" and select "Tasks" > "Copy Database.". Here is how you can copy a database from a 2012 server instance to a 2008 R2 instance: There are numerous methods you can adopt to "downgrade" a database, but one I have found recently and that I believe was not found in early releases of SQL MS 2012, is the Copy Database Wizard. NOTE, SOME OF THE ABOVE ANSWERS ARE MASSIVELY OUT-OF-DATE! THIS CAN BE DONE AND ALL WITHIN SQL SERVER MANAGEMENT STUDIO (SQL MS)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |