Export contents of SQL 2000 table to overwrite another table?
Posted on 2009-04-23
I'm running SQL Server 2000 on a Windows Server 2003 machine, and I've got multiple databases set up, some of which are clones.
As of sometime last week, one of the tables in our primary database was damaged, and I'm trying to export the data from it's clone to that table. I want to go from one database table to another database table, copying the data but retaining the destination table's identification. Basically I just need to replace the damaged data with good data.
I'd prefer to use the Import/Export wizard if possible, as I'm not very good at SQL statements. Any help would be appreciated.