MBS Copy MS SQL table from one server to another

I need to copy a table from one server to another

MS Sql

I do need to use a select to get the records and columns to copy as i don’t always need every record nor every column.

I have Xojo and MBS.

What’s the best way to do this?

Thanks
Alan

Have a look at https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-ver16

What do you use already?

One thing could be to make a select in old and new table to find just the record IDs and then look which are missing. Then do a full select for batches of 100 records in one table and run insert commands for them in the other table.

I have had good luck using https://dbconvert.com/ to copy schema/data and synchronize rather than doing it by hand.