Create a new SQL DB then copy tables and data from MS Access DB

• hex226

  Old Hand

  Points: 340

  More actions

  December 7, 2023 at 10:55 am

  #4341456

  Hi,

  I'm looking for some advice and to find out if the following is possible.

  I have an Access DB that get's updated each week, In order to improve our reporting, I'd like to create a new SQL DB each week, with a copy of the Access DB tables and it's data. I want to automate this, and feel PowerShell could be the answer.

  It feels fairly straightforward to do something like this, but is it possible in PowerShell, and is it as easy as it sounds?

  Any help or guidance to point me in the right direction to start this, is much appreciated.

• Phil Parkin

  SSC Guru

  Points: 247155

  More actions

  December 7, 2023 at 11:04 am

  #4341457

  Does the schema of the Access DB also change much?

  If not, it would be better, in my opinion, to build a process to refresh the data in your SQL Server database every week, using the updated Access DB as the data source.

  ---