April 14, 2015 at 10:10 am
Hi,
I was using sql server 2014 trial version. We bought sql server 2012 now.
How can we setup sql server 2012 ?
Will it make any problem while restoring Databases to sqlserver 2012?
Regards,
Geo
April 14, 2015 at 10:37 am
geoforu (4/14/2015)
Hi,I was using sql server 2014 trial version. We bought sql server 2012 now.
How can we setup sql server 2012 ?
Will it make any problem while restoring Databases to sqlserver 2012?
Regards,
Geo
You cannot restore to a lower version but if you install side by side then you can import to the lower version.
😎
April 14, 2015 at 10:48 am
As mentioned, you cannot restore databases. You could use a copy to move tables, objects, data from one version to the other.
If you are trying to install on the same machine, your 2012 version will be a named instance, and not a default, assuming that 2014 is your default instance.
April 14, 2015 at 11:08 am
You really shouldn't have anything in a trial environment that you're not ready to throw away. After all, the tests could have just failed.
But as others have said, export/import is your only answer. You can't do a backup and restore.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 14, 2015 at 11:17 am
Further on the install, I've had no problems installing 2012 alongside existing 2014 unlike previous versions.
😎
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply