how can i import sqlserver 2000 data into 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how can i import sqlserver 2000 data into 2005

Author

Topic

Maachie
Yak Posting Veteran

69 Posts

Posted - 2009-03-11 : 15:16:06

Hi,

I have sql server 2000 on one laptop. I bought a new Mac Air book with parallels. I want to import data from 2000 from my old laptop into my new laptop that has sql 2005. How would i do that?

Thanks,
Maachie

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-11 : 15:21:28

If both servers can see each other through network link; you can use the SQL Server 2005 Import/Export wizard... (Assuming you db already exists on 2005).

If it doesn't you can take a full backup on 2000 and restore it on 2005.

Thanks.

Mohit.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

savior faire
Posting Yak Master

194 Posts

Posted - 2009-03-11 : 15:25:13

Mohit,
I am just curious, SQL 2000 backups can be restored to a SQL 2005 Database? I specifically recall that one had to do a migration from 2000 to 2005. If one could merely restore a 2000 backup, then upgrading/migrating to SQL 2005 would be fairly easy.

Talk sense to a fool and he calls you foolish.

dellgx270
Starting Member

6 Posts

Posted - 2009-03-11 : 15:30:58

you can detach database in sql server 2000 then copy it come to sql server 2005.
end you can attach.
I think so.

Always try for success!

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-11 : 15:31:52

It is easy ;-) well most cases heh. You can restore SQL Server 2000 backup on to SQL Server 2005, when restoring the backup it SQL Server will upgrade the meta data of the database to 2005. So you will not be able to revert back, but it will work :).

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Maachie
Yak Posting Veteran

69 Posts

Posted - 2009-03-11 : 15:31:58

Do I have to create the database with all the tables and fields in 2005 before I import? I assume yes.pls clarify

Also,
If both servers can see each other through network link; you can use the SQL Server 2005 Import/Export wizard... (Assuming you db already exists on 2005).

They are two different laptops and the sql is installed on the laptops.
is there any example you would direct me to?

Thanks,
Maachie

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-11 : 15:47:13

No you don't have to create tables the import utility will create them for you.

Are both laptops on a network (local) via a wireless or connected to a router? Then you should be able to communicate with the SQL Server on your network. I don't have any examples on how to setup network for you sorry...

For Import/export wizard if you search google you should be able to find some good articles :).

Mohit.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

hey001us
Posting Yak Master

185 Posts

Posted - 2009-03-11 : 15:55:10

Based on my understanding, you’re upgrading SQL 2000 to SQL 2005.

You can follow up what Guptam mentioned in last post. It’s a easy way. No need to do anything on SQL 2005 if you restore.

Bear in mind you can’t revert back to SQL 2000 as he mentioned already.

hey

Maachie
Yak Posting Veteran

69 Posts

Posted - 2009-03-12 : 09:38:28

Hi,

I tried importing sql2000 data from old laptop to the new laptop sql2005.
I have 2000 and 2005 in old laptop.
I have 2005 only in new laptop.

During the import process, I am able to only see 2000 server from old and 2005 server from new and not 2005 from old laptop.

Error msg:

Unable to complete login process due to delay in opening server connection (Microsoft SQL Native Client)

Can someone help me with this?
Thanks,
Maachie

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-03-12 : 09:57:54

Why don't you just backup the SQL 2000 database and restore it to the SQL Server 2005 instance?

This is usually the simplest way to do it.

CODO ERGO SUM

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-12 : 10:20:35

Hi Maachie, It seems they are not connected together via network or such. But I agree with Michael why not just backup/restore?

Mohit.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Maachie
Yak Posting Veteran

69 Posts

Posted - 2009-03-13 : 11:08:45

Hi,

I tried importing sql2000 data from old laptop to the new laptop sql2005.
I have 2000 and 2005 in old laptop.
I have 2005 only in new laptop.

During the import process:
From my new laptop, I am able to only see 2000 server tht is in my old laptop. I do not see 2005.

And

From my old laptop, I am able to see 2005 server that is in my new laptop.

Basically, i am able to see the servers on both the laptops. What i don't understand is when it comes to pick the database I get this error.

Error msg:

Unable to complete login process due to delay in opening server connection (Microsoft SQL Native Client)

Can someone help me with this?

I have a macair book and on vmware the sql is installed. Old laptop is dell. Does this got something to do with the error i get?

Thanks,
Maachie

guptam
Posting Yak Master

161 Posts

Posted - 2009-03-13 : 12:00:04

Check out ...http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

If all these network issues don't resolve take a full backup of the database on your old computer; but on USB Drive, go to new laptop copy the backup over and restore the database ...

Thanks.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources