Dec 27, 2006 #1 jibberski Programmer Aug 24, 2005 52 US The sql server 2005 upgrade was cut from my budget. I'm developing a client app utilizing sql 2005 express and sql server 2000. Is it possible to use SQL 2000 DTS (or any other methods) to broadcast upgrades to the client machines ?
The sql server 2005 upgrade was cut from my budget. I'm developing a client app utilizing sql 2005 express and sql server 2000. Is it possible to use SQL 2000 DTS (or any other methods) to broadcast upgrades to the client machines ?
Dec 27, 2006 #2 mrdenny Programmer May 27, 2002 11,595 Yes DTS can connect to SQL 2005 machines provided that the SQL 2005 Express install to setup to allow remote connections. Denny MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com Upvote 0 Downvote
Yes DTS can connect to SQL 2005 machines provided that the SQL 2005 Express install to setup to allow remote connections. Denny MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005) --Anything is possible. All it takes is a little research. (Me) http://www.mrdenny.com