How to convert sql server 2000 to sql server 2008

Question

0.00/5 (No votes)

See more:

i Sir,

I am using SQL SERVER 2000 now , but i want to migrate it in to SQL SERVER 2008 how i suppose to proceed?

Thank You

ANil Banjare

Posted 26-Mar-12 20:55pm

Member 3567411

Add a Solution

2 solutions

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)

OriginalGriff · Answer 1 · 2012-03-26T21:04:00

Solution 1

Install SQl Server 2008, and change your connection strings to use the new instance when you have copied the appropriate database.

Why? Are you getting a specific problem?

Posted 26-Mar-12 21:04pm

OriginalGriff

Comments

Member 3567411 27-Mar-12 6:24am

I have converted database from sql server 2000 to 2008. Also I have copied web based application which is designed in framework 1.1 to framework 4.0. But database connectivity is not working, it is showing time out error.

OriginalGriff 27-Mar-12 6:33am

Probably, it is your connection string. Have you tried a connection via Visual Studio Serever Explorer pane / SSMS?
Try setting up a connection in VS with the Server Explorer pane:
1) Open Server Explorer.
2) Right click "Data connections" and select "Add connection"
3) In the dialog that follows, select your DataSource, and database, specify the security info, and press the "Test connection" button.
4) When the connection works, press "OK"
5) Highlight your database in the Server Explorer pane, and look at the Properties pane. A working example of the connection string will be shown, which you can check against your existing one.
If you can't connect that way, you need to start looking at firewall settings, and related gubbins.

Member 3567411 28-Mar-12 1:38am

Hi Sir

We followed your steps but we are getting error as below.

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".

Thank You

OriginalGriff 28-Mar-12 3:09am

Then you need to look at firewall settings on first the PC hosting SQL server, and then your PC.
Until you can get a connection with VS or SSMS you will not get any connection with your code.

Member 3567411 28-Mar-12 6:04am

Hi Sir,

When i am changing the connection string from our application . it is not changing run time, it is taking old connection string automatically.
Please help.

Thank You

OriginalGriff 28-Mar-12 6:18am

I can't - I can't see your screen or tell how you are storing it, loading it, where you get it form, etc., etc.
Either I would need a lot more detail, or you need to look at your code! :laugh:

naik_sushil · Answer 2 · 2012-03-26T21:13:00

Solution 2

Hi,

Have look on the below post

http://stackoverflow.com/questions/5620269/migrate-from-sql-server-2000-to-2008-r2-how-to[^]

Posted 26-Mar-12 21:13pm

naik_sushil