I have a general question about copying tables. We have a front end / back end database. Nightly, the back end data has an automated scheduled transfer from a shared network to a SQL database. If that process fails is there any issues running the data transfer during the day when users are using the front end? There are about 12 tables that transfer. The most used table has about 300 of new lines of data daily.
Data tables transfer
- Thread starter Jake94
- Start date
neileg
AWF VIP
- Local time
- Today, 07:42
- Joined
- Dec 4, 2002
- Messages
- 5,975
I assume that the tables are related in some way. There's a danger that if you transfer the data while the database is live that you will get incomplete datasets if the entries in one or more of the tables are unsaved at the moment in time.
Atomic Shrimp
Humanoid lifeform
- Local time
- Today, 07:42
- Joined
- Jun 16, 2000
- Messages
- 1,954
Isn't it possible just to migrate the back end tables permanently to SQL Server - and relink them into the front end?
Then as long as there's a sensible backup policy on the server, there should then be no need for the nightly copy.
Then as long as there's a sensible backup policy on the server, there should then be no need for the nightly copy.
Mike - Thanks for the confirmation. Yes, they are related. It is a copy of the same tables from multiple locations that are combined on the SQL server.
neileg - I agree that would be a better solution. However, it involves costs. A copy of the database is in multiple locations 1000 miles apart. They wanted to keep good local response. At a future time they will fund a single interface for all locations. Thanks!
neileg - I agree that would be a better solution. However, it involves costs. A copy of the database is in multiple locations 1000 miles apart. They wanted to keep good local response. At a future time they will fund a single interface for all locations. Thanks!
