0

This question already has an answer here:

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:

  • Is it possible to migrate my SQL Server 2012 sharepoint database to SQL Server 2008? Will the new database be compatible with my sharepoint?
  • could you please send me a link with the instructions?

thank you very much

marked as duplicate by Kin Shah, RolandoMySQLDBA, Philᵀᴹ, Mark Storey-Smith, Paul White May 28 '14 at 5:59

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Never heard of Sql Server 2010. Could you try "SELECT @@version" within SSMS to give us the proper version? My bet would be on 2008R2. – KookieMonster May 27 '14 at 6:31
  • sorry @KookieMonster I ment SQL Server 2012... my mistake – Manuel Sopena Ballesteros May 27 '14 at 7:12
0

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

  • will that script create all users, permissions, etc on my new db instance? – Manuel Sopena Ballesteros May 28 '14 at 4:28
0

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.

  • Suggesting purchasing software as the 'only' way to do something, when it isn't, is misleading... – Mark Sinkinson May 27 '14 at 9:11
  • Sometimes the pressure is so high that purchasing is the way out – user193655 Jun 26 '15 at 13:31

Not the answer you're looking for? Browse other questions tagged or ask your own question.