Running SQL Select script between SQL servers

[itrcpo]

I have 2 SQL servers, one SQL 7 and another SQL 2000.

The SQL 7.0 server is the "Master" DB, and every 30 minutes i run a stored procedure on the SQL 2000 server which "copies" all the new entries from the SQL 7 to the SQl 2000 server.

Normally it is about 200 new entries, but it always take about 1,5 minutes to run?

I have tried to select and insert 5000 entries, just to check the performance, and that also took about 1,5 minute?

Are there anyone who have tried the same?

Christoffer

 

[ClaireHCM]

You can create trigger on table for insert!
Writing new inserts into a temp table
schedule job to check the temp table every "x" mins.
If the temp table possesses rows,use select into to insert them into 2000 server and also
truncate the temp table soon after inserting all the existing rows in the temp table.