How to install database files to target machine[Updated version]

Question

0.00/5 (No votes)

See more:

, +

Hey everyone.

So I have made a set up file and install it to target computer which has no .Net 4.0 or sql server 2008.
I add them as prerequities and setup downloaded from the internet the .Net 4.0 and sql server 2008.
The setup finished succesfully. When I run the program, it gives an exception:

say: can not open xxxxxx.mdf file. it is version 650. and your is xxx...

I searched it out and learnt that the sql server installed on target computer is lower than the database file I created(The database file created in 2008 r2). So, no connections can be opened.

To solve this, What can I do?

Thank you...

Posted 20-Jun-12 22:08pm

Un_NaMeD

Updated 21-Jun-12 7:03am

v4

Add a Solution

Comments

OriginalGriff 21-Jun-12 4:36am

What happened when you tried? Where did you have problems?

Un_NaMeD 21-Jun-12 4:49am

When I run the setup.exe, an error poped out and says the installer can't be run. Don't understand why. is there any other way except the link?

OriginalGriff 21-Jun-12 5:02am

Any particular error? Or just a big box that said "ERROR" and refused to give you any other information?

Un_NaMeD 21-Jun-12 8:35am

it says: error 1001 exception occurred while initializing the installation...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

db7uk · Answer 1 · 2012-06-21T09:38:00

The problem is that you can not attach your mdf to an SQL instance that is lower than the version the mdf was created in. I might well be wrong but you will need to update your server with the R2 version of sql and not base 2008 version it is currently.

UPDATE 1

It just occurred to me that you could generate scripts for your 2008 database and use those scripts to create an R2 version on the server.

UPDATE 2

Just seen you other post about the same topic on StackOverflow:

http://stackoverflow.com/questions/11143612/cannot-attach-2008-r2-database-to-2008-instance[^]

People are suggesting the same. However, There is an interesting link here: http://robindotnet.wordpress.com/2011/02/06/how-about-a-bootstrapper-package-for-sqlserver-express-2008-r2/[^] on creating an SQL express 2008 R2 bootstrapper (pre-requsite) that you maybe able to use.

The only problem is that if we are talking about server environments, is it wise to have a pre-req in this manner? should the infrastructure support not be notified and manage a server upgrade (including service packs)??? Installing an application that does this for someone's server could be quite harsh???