| Author |
 Topic  |
|
funketekun
Constraint Violating Yak Guru
Australia
491 Posts |
 Posted - 05/13/2008 : 23:50:30
|
best way to copy the whole db from 2k5 to 2k.
thanks |
|
|
sodeep
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 05/13/2008 : 23:52:51
|
| SSIS,bcp. |
 |
|
|
funketekun
Constraint Violating Yak Guru
Australia
491 Posts |
Posted - 05/14/2008 : 00:40:49
|
2k doesnt support 2k5 db. PLS
Pls only experts! No noobies. |
|
|
|
ratheeshknair
Posting Yak Master
India
129 Posts |
Posted - 05/14/2008 : 02:15:30
|
Use export-import utility in SQL 2K5.Thats the simplest way.
RKNAIR |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 05/14/2008 : 02:31:17
|
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 |
|
|
|
DavidChel
Constraint Violating Yak Guru
USA
474 Posts |
Posted - 05/14/2008 : 09:12:08
|
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. |
|
|
|
sodeep
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 05/14/2008 : 09:51:49
|
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 |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 05/14/2008 : 10:07:37
|
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 |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 05/14/2008 : 10:34:15
|
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. |
|
|
|
sodeep
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 05/14/2008 : 10:39:10
|
 |
|
|
|
jsmith8858
Dr. Cross Join
USA
7423 Posts |
Posted - 05/14/2008 : 10:42:04
|
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
|
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 05/14/2008 : 11:48:10
|
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? |
|
|
|
funketekun
Constraint Violating Yak Guru
Australia
491 Posts |
Posted - 05/14/2008 : 11:49:24
|
| ok relax i think i got it. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
funketekun
Constraint Violating Yak Guru
Australia
491 Posts |
Posted - 05/14/2008 : 12:35:51
|
damn its not working.
anyone know how to do it?
i used the copy object from ssis and it didnt work |
|
|
|
sodeep
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 05/14/2008 : 12:40:07
|
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. |
|
|
|
funketekun
Constraint Violating Yak Guru
Australia
491 Posts |
Posted - 05/14/2008 : 12:46:03
|
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? |
|
|
|
funketekun
Constraint Violating Yak Guru
Australia
491 Posts |
Posted - 05/14/2008 : 12:46:50
|
| looks like u dont know or something. |
|
|
|
Topic |
|
2k5 to 2k
