| |

VerySource

 Forgot password?
 Register
Search
View: 803|Reply: 2

ACCESS database and SQL SERVER data synchronization scheme

[Copy link]

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-3-10 14:30:01
| Show all posts |Read mode
An existing system uses two sets of databases, namely ACCESS and SQL SERVER.
Is there any way to make the two data automatically update the data regularly and save and synchronize!
Reply

Use magic Report

0

Threads

23

Posts

15.00

Credits

Newbie

Rank: 1

Credits
15.00

 China

Post time: 2020-8-18 18:30:01
| Show all posts
If you process in Access, use linked tables or transfer queries, you need to handle the timing processing yourself.

If the job is processed in SQL Server, OpenDataSource, OpenRowSet, linked server, etc. are all available.
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 Ethiopia

Post time: 2020-8-18 18:45:01
| Show all posts
You can use the dts function that comes with sqlserver.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list