@Emperor100

How many employees are you trying to process?

we have about 60 employees.

If it is not huge and I hope the legacy data changes not going back beyond a year, in...

Most likely I wasn't clear.

Sample data I shown are part of data read from a view belonging to a third-part legacy dabase . I have no control overt that but...

Thank you very much !!!

Hi,

below is the code I wrote to import data from remote database.

On the remote database I have a view with data I need to import.

On the local SqlServer instance I've...

Thank you very much!

The staging table is a "copy" of the remote table with only the relevant data ?

Is it fair to assume that you cannot change the remote DB at all?

Absolutely. I have only read access to some views. It's a legacy application Sql database.

I'd make the...

You're right, sorry. Wrong place 🙂

But the main question is basically  : sync or not to sync ?

To answer your questions : remote data doesn't have fields like datecreated or...

• This reply was modified 1 year, 6 months ago by  spilo.

Thanks, but that’s not an option.

I'm sorry for my bad English which certainly does not help in understanding what I need.

My initial question was : is it a good choice...

Hi, thank you for your replies.

We already have a legacy software to keep track of time/attendance. But it has some limitations.

It can monitor employee hours, absence , overtime, etc.

The software...