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
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alpesh PatelAssistant ConsultantCommented:
Please reduce the compatibility mode of Local box database to Standard 2008 version.

Backup it and restore to Server.
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Try this-
# Open SQL Server Management Studio R2
# Select your source Database
# Select Tasks>Generate Scripts.
# Select 'Script entire database and all database objects', press 'Next'
# Select 'Save to File' and click on the 'Advanced' button
# Select 'Script for Server Version' and select the version you want: 200/2005/2008
# Select 'Type of data to Script' and select Schema/Data/both
# Click 'OK',Next and do it!
# Copy the resulting file to the target machine with SQL 2008 [or whatever]
# Log onto your SQL Management Studio and open the copied .sql file... be aware that there may be limitations on the file size.
There may also be issues with the order that the .SQL file inserts the data into the target database and if there are FK constraints in place, this could be an issue.... simply re-order the insert lists.
# Once the .sql file is organised, parse it [just to sure], and then execute.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
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.
websssCEOAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.