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 - 2002-11-29 : 09:41:26
|
| Joseph Lucier writes "All objects except views can be transferred from SQl 6.5 to sql 2000. Has anyone had luck transferring SQL 6.5 views using DTS?" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-29 : 09:58:36
|
| You can script the views, and then create them on the 2000 server. If you use DTS, you'll only get the "snapshot" data from the view. |
 |
|
|
|
|
|
Transfer 6.5 Views to SQL 2000 using DTS Impossible