December 18, 2013 at 3:59 am
hi
i dont english good and i will attach database form sql2008r2 to sql 2008 and problem for attach
plase help me
best regard
December 18, 2013 at 4:14 am
Can't be done.
A SQL 2008 R2 database can only attach to SQL 2008 R2 or SQL 2012. SQL Server does not allow downgrading of database versions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2013 at 4:14 am
It is not possible to detach/attach a database from a higher version (SQL2008 R2) to a previous version (SQL 2008). You also can not restore a backup to a previous version.
The only way to transfer the data is to script-out the definition and to import all the data.
December 18, 2013 at 5:50 am
very thanks for all helps.
i create script from database file but in another system with sql2008 not run and error
how to script and run script in sql2008.
best regard
December 18, 2013 at 6:02 am
Right click database -> tasks -> generate scripts.
Don't script the data, use import/export once you've created the database on SQL 2008.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2013 at 6:25 am
very thank for guide my problem
i have a database with table ,procedure,trigger,view with sql2008r2 in a one system
and i will transfer data a another system with sql 2008
i have n't export from database.
database/task/export/.
i can not export store procedure from database.
please help me
best regard
December 18, 2013 at 7:00 am
fateme.soleimani67 (12/18/2013)
very thanks for all helps.i create script from database file but in another system with sql2008 not run and error
how to script and run script in sql2008.
best regard
Make sure you first set the option in SSMS to create SQL2008 scripts:
- in SSMS go to menu "Tools"
- select menu-option "Options"
- navigate to and expand "SQL Server Object Explorer"
- Click on "Scripting"
- select "SQL 2008 Server" as option for item "Script for server version"
December 18, 2013 at 10:02 am
i create script and copy and paste in another system and open file scrip and click run but i face error:
database doesn't exist .
i set sqlserver2008r2 in script for server version.
please help me
best regards.
December 18, 2013 at 10:25 am
my problem solved.
very very thanks for your guide.
best regards.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply