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 |
|
Dev@nlkss
134 Posts |
 Posted - 2009-01-08 : 01:45:55
|
| Hi Allwe are maintaining two servers one is running on SQL Server 2000 one is on SQL Server 2005.What I want to do is I have to copy some tables data from SQL2000 DB to SQL2005 DB on everyday on perticuler time.What is the best way to automate this process in sql 2005.Can i Use SSIS if so please explain the process Or any other way.Its very urgent.Thanks in advance.Satya |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-08 : 04:12:47
|
You can use linked server and then your query to copy the data in a stored procedure.This stored procedure you can start in scheduled SSIS Job.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-08 : 09:40:24
|
| You can use export/import wizard and make it as SSIS package ,schedule it. |
|
|
|
|
|
|
SQL Server