Post reply

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

  • 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.

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply