Friday, February 17, 2012

Data From SQL 2000 to SQL 6.5

We're running production on an SQL 2000 server but still use and old
6.5 server for test purposes.
Is there a way to copy data from a table on the 200 server to the same
table on a 6.5 server?
Thanks!!!Some options are: DTS, BCP, BULK INSERT, INSERT... SELECT and SELECT INTO (
last two ones over a
linked server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John" <jhenk17@.yahoo.com> wrote in message
news:1142610016.021081.56310@.j52g2000cwj.googlegroups.com...
> We're running production on an SQL 2000 server but still use and old
> 6.5 server for test purposes.
> Is there a way to copy data from a table on the 200 server to the same
> table on a 6.5 server?
> Thanks!!!
>

No comments:

Post a Comment