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 |
|
kodali12
Starting Member
2 Posts |
 Posted - 2011-07-13 : 02:13:54
|
| hiWe have a reqirement in SQL Server where source is SQL Server 2005 and the target is SQL Server 2007. Table format is same in both the DB's and this data dump is a daily activity based some filter critiria. Please let me know this can be achived with SQL Server stored procedure?Thanks,Narendra |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-13 : 02:18:31
|
There is no SQL server 2007.And sorry, I can't understand what you want...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-07-13 : 02:58:13
|
| you can achieve it by DTS,and FYI there is no sql server 2007 instead there is sql server 2008. |
|
|
|
kodali12
Starting Member
2 Posts |
Posted - 2011-07-13 : 04:08:25
|
| Thanks for the reply, target is SQL Server 2008, We have DataStage as ETL tool with this we can achive but we have some infrastructure issues to use that tool and we looking for work around as this is not a one time task. Any help will be appriciated. |
|
|
|
|
|
|
SQL Server Procedure