Assuming you are using sql 2k I would say use a global variable to assign the date of the information you want to pull and only move those as apposed to trying to link the tables across servers... sorry I do not know Pervasive so you may not be able to do this.