SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 2k5 to 2k
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

funketekun
Constraint Violating Yak Guru

Australia
491 Posts

Posted - 05/13/2008 :  23:50:30  Show Profile  Visit funketekun's Homepage  Reply with Quote
best way to copy the whole db from 2k5 to 2k.
thanks

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/13/2008 :  23:52:51  Show Profile  Reply with Quote
SSIS,bcp.
Go to Top of Page

funketekun
Constraint Violating Yak Guru

Australia
491 Posts

Posted - 05/14/2008 :  00:40:49  Show Profile  Visit funketekun's Homepage  Reply with Quote
2k doesnt support 2k5 db. PLS

Pls only experts! No noobies.
Go to Top of Page

ratheeshknair
Posting Yak Master

India
129 Posts

Posted - 05/14/2008 :  02:15:30  Show Profile  Click to see ratheeshknair's MSN Messenger address  Send ratheeshknair a Yahoo! Message  Reply with Quote
Use export-import utility in SQL 2K5.Thats the simplest way.

RKNAIR
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 05/14/2008 :  02:31:17  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
SQL 2005 databases cannot be attached to a SQL 2000 instance. Backups of a SQL 2005 database cannot be restored on SQL 2000.

You will have to, as SoDeep suggested, script the database out and bcp the data out. Apply the script on a SQL 2000 server then import all the data

--
Gail Shaw
Go to Top of Page

DavidChel
Constraint Violating Yak Guru

USA
474 Posts

Posted - 05/14/2008 :  09:12:08  Show Profile  Reply with Quote
quote:
Originally posted by funketekun

2k doesnt support 2k5 db. PLS

Pls only experts! No noobies.



It amazes me that anybody bothers to answer him anymore.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/14/2008 :  09:51:49  Show Profile  Reply with Quote
quote:
Originally posted by DavidChel

quote:
Originally posted by funketekun

2k doesnt support 2k5 db. PLS

Pls only experts! No noobies.



It amazes me that anybody bothers to answer him anymore.


funketetun,
Stop writing 'Pls only experts! No noobies.'.It irritates people


Edited by - sodeep on 05/14/2008 09:52:30
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 05/14/2008 :  10:07:37  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
quote:
Originally posted by DavidChel

quote:
Originally posted by funketekun

2k doesnt support 2k5 db. PLS

Pls only experts! No noobies.



It amazes me that anybody bothers to answer him anymore.



I just wanted to see if he replied saying I was too much of a 'noobie' to be of any help.


--
Gail Shaw
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 05/14/2008 :  10:10:02  Show Profile  Reply with Quote
EX-SPURT

A former drip under pressure



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 05/14/2008 :  10:34:15  Show Profile  Reply with Quote
Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database.

Hopefully that is exshpurt enough for you.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/14/2008 :  10:39:10  Show Profile  Reply with Quote
Go to Top of Page

jsmith8858
Dr. Cross Join

USA
7423 Posts

Posted - 05/14/2008 :  10:42:04  Show Profile  Visit jsmith8858's Homepage  Reply with Quote
quote:
Originally posted by funketekun

2k doesnt support 2k5 db. PLS

Pls only experts! No noobies.



funketun -- if you post "experts only" one more time, I am going to discuss this with the other moderators and we'll probably lock your account. It's rude, it's not funny, enough is enough.

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 05/14/2008 :  11:19:37  Show Profile  Reply with Quote
quote:
Originally posted by jsmith8858

quote:
Originally posted by funketekun

2k doesnt support 2k5 db. PLS

Pls only experts! No noobies.



funketun -- if you post "experts only" one more time, I am going to discuss this with the other moderators and we'll probably lock your account. It's rude, it's not funny, enough is enough.

- Jeff
http://weblogs.sqlteam.com/JeffS





Where's crespo?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 05/14/2008 :  11:21:37  Show Profile  Reply with Quote
hey dba in..

http://en.wikipedia.org/wiki/Saint_Barth%C3%A9lemy

Good job



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 05/14/2008 :  11:48:10  Show Profile  Reply with Quote
quote:
Originally posted by funketekun

quote:
Originally posted by RickD

Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database.

Hopefully that is exshpurt enough for you.



we have like many tables. i cant do that.


Then why ask stupid questions and then ignore the replies you get that actually tell you how to do what you asked?
Go to Top of Page

funketekun
Constraint Violating Yak Guru

Australia
491 Posts

Posted - 05/14/2008 :  11:49:24  Show Profile  Visit funketekun's Homepage  Reply with Quote
ok relax i think i got it.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 05/14/2008 :  12:12:03  Show Profile  Reply with Quote
quote:
Originally posted by funketekun

ok relax i think i got it.



What? STD? (which is DTS spelled backward)





Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

funketekun
Constraint Violating Yak Guru

Australia
491 Posts

Posted - 05/14/2008 :  12:35:51  Show Profile  Visit funketekun's Homepage  Reply with Quote
damn its not working.
anyone know how to do it?
i used the copy object from ssis and it didnt work
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/14/2008 :  12:40:07  Show Profile  Reply with Quote
Do as RickD has said? you won't miss any data.

"Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database.
" Classic one.
Go to Top of Page

funketekun
Constraint Violating Yak Guru

Australia
491 Posts

Posted - 05/14/2008 :  12:46:03  Show Profile  Visit funketekun's Homepage  Reply with Quote
quote:
Originally posted by RickD

Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database.

Hopefully that is exshpurt enough for you.



using ssis or bcp?
can u elaboreate?
Go to Top of Page

funketekun
Constraint Violating Yak Guru

Australia
491 Posts

Posted - 05/14/2008 :  12:46:50  Show Profile  Visit funketekun's Homepage  Reply with Quote
looks like u dont know or something.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.48 seconds. Powered By: Snitz Forums 2000