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 |
|
yatesy87
Starting Member
8 Posts |
 Posted - 2006-05-03 : 07:25:45
|
| Currently we have two SQL servers, one which holds data for all enquiries which are brought in to us from our stores around the UK and the other SQL server is the telesales server to dial numbers.What we are trying to do now is transfer data in a stored procedure from the SQL 7 to SQL 2000 server.Now I know that the SQL query would have a inset statement with a sub query to select the data from the sql 7 server, my question is how do i adctually make it take and select data from the sql 7 server? |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-05-03 : 07:29:07
|
| if you are migrating data from one server to another, why dont you use Data tranformation Service (DTS) tool of SQL Server 2000.. If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
|
|
|
Transfer from SQL 7 to SQL 2000