Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lewie
Starting Member
42 Posts |
 Posted - 2013-09-19 : 03:19:31
|
| I need to transfer an Access DB to SQL on a regular basis. Any ideas on how this would best be achieved? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-19 : 08:38:30
|
quote:
Originally posted by Lewie
I need to transfer an Access DB to SQL on a regular basis. Any ideas on how this would best be achieved?
Depends on the details. If you want to export the data in an Access DB to a SQL Server database on a regular basis, use SSIS.If you want to CONVERT an Access DB to a SQL database on a regular basis, manual intervention will be required each day. You can upsize an Access DB to a SQL DB. |
 |
|
|
|
|
|
MS ACCESS to SQL