Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have been looking for the information since yesterday and could not find anything... I have sharepoint 2012 fundation and my SQL Server 2010 Evaluation is short of space (we already used 10GB), however I have SQL Server 2008 R2 license.
Question:
thank you very much
Migrating from SQL Server 2012 to 2008 is not only possible, it can be done entirely within SSMS, with no need to purchase additional software.
You'll need to run the Generate Scripts wizard, target Server Version SQL Server 2008 and then run the scripts generated to import all the data to your new database.
With larger databases, it may be a bit of a lengthy task, so script the minimal amount of data that you'll actually need
One way to do this is to use a tool such as Redgate SQL Data Compare. I have had to do this in the past and it has worked well. First you run a schema compare to create an empty database in the 2008 server and then run data compare to pump the data in.
There are other vendors offering similar tools and I believe the new Visual Studio also has something like this. The Redgate offering does give you a two week trial which may be good if you only need it for a one of migration.
Click here for the trial.
