Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot attach a database from one version to another
Message
From
20/11/2014 12:06:48
 
 
To
20/11/2014 11:45:50
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01611241
Message ID:
01611248
Views:
33
>>You can't attach or restore DB from bigger version of SQL Server to smaller one.
>>You can't even do that from 2008 R2 to 2008 (go figure!).
>>One way is to script DB as Nicholas suggested.
>>Other way is to use Import/Export wizard.
>
>I cannot script if the database is too big.
>
>I will have to check for the Import/Export.
>
>Thanks

You could just script the structure and then move the data by maybe linking servers or work out you own data segments and select those out into temporary tables etc
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform