|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "John" <jhen***@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!!! >  
Other interesting topics
SQL 2000 on W2k fragmentation
Performance: Primary Key = int/nvarchar/guid/... TSQL help to delete How do I get my local data in the database on the Internet? Switching off logging on varbinary column Multiple jobs on one schedule Memory allocation in MS-SQL 2000 instances Windows says SQL is installed, but it's not! Why do Ado.net don't use execution plan that Query Analyzer Query suddenly becomes very slow |
|||||||||||||||||||||||
