I need to append a table from a SQL Server database into another table of the same name and same structure in another SQL Server database.
In Visual FoxPro, this can be done with the APPEND FROM command. Is this a mystery or I couldn't find a command like for SQL Server? Do I have to do a Visual FoxPro program to loop for each record and insert them manually into the other table?