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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-03 : 12:09:25
|
| Srinivas writes "Iam newbie to data imports, I have a table with millions of records on sql6.5 box, and the same structure lies on sql2000 box. I want to copy the data from the table on sql6.5 to sql2000 box in such a way that the triggers on the table at sql2000 should get fired.If any body can give me the solution in a step by step manner, it would be great.Thanks in advanceSkanala" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-03 : 12:22:13
|
| Have you tried using DTS. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-03 : 12:30:35
|
| If you went the way of DTS/bcp, I'm not sure if the triggers would fire, but it's worth a shot since this would be the preferred method.You could also create a linked server on the sql2000 box pointing to the 6.5 box. Then run a insert into/select * from query. The select * part would reference the 4 part name of the 6.5 table. |
|
|
|
|
|
|
Data import from sql 6.5 to sql 2000