sql server 2008 r2 > sql server 2008 - compatibility problem restoring
my local box is running r2 and the server is running the standard version of 2008
i want to get a database from my local box to the server however when i try i get the the comaptibility issue....because of different versions
i need to know the steps to get the database onto the server
I tried export data but i'm getting errors
i tried generate scripts but that had issues also
i'm looking for the steps or a tutorial in case i'm missing anything
thanks
i want to get a database from my local box to the server however when i try i get the the comaptibility issue....because of different versions
i need to know the steps to get the database onto the server
I tried export data but i'm getting errors
i tried generate scripts but that had issues also
i'm looking for the steps or a tutorial in case i'm missing anything
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rightclick on your database name on the SQL Server R2 box
Goto properties and then to options
From the compatibility level dropdown box select "SQL Server 2008"
Press Ok....
Now you can backup the database and restore it in your 2008 server.
Goto properties and then to options
From the compatibility level dropdown box select "SQL Server 2008"
Press Ok....
Now you can backup the database and restore it in your 2008 server.
The compatibility mode won't work. It's the backup file itsels that has a different version.
Actually you could try the 'move database' feature of SSIS.
Actually you could try the 'move database' feature of SSIS.
ASKER
worked!
Backup it and restore to Server.