Graduarly moving my tables into SQL Server.
Each day at 19:00 i run a update query that copies 4 fields from a read only database, to a archive table (So i never loose the data) the read only database has approx 400,000 records, so daily i run a update query to store the data for any jobs that have been carried out today, and save that data in a archive table.
The tables are on 2 different servers - which are both connected via Access. Today i had to stop the query after about 30 minutes as it was just not running.
What would be the quickest way to run this query - I am assuming within SQL.
IF so - How do i run the query when it is linked to 2 different servers ?
Or would i be better coping a table to my Access fonr end 0 running the data from there and then copying the updated data back ?
Each day at 19:00 i run a update query that copies 4 fields from a read only database, to a archive table (So i never loose the data) the read only database has approx 400,000 records, so daily i run a update query to store the data for any jobs that have been carried out today, and save that data in a archive table.
The tables are on 2 different servers - which are both connected via Access. Today i had to stop the query after about 30 minutes as it was just not running.
What would be the quickest way to run this query - I am assuming within SQL.
IF so - How do i run the query when it is linked to 2 different servers ?
Or would i be better coping a table to my Access fonr end 0 running the data from there and then copying the updated data back ?
