Post reply

one-off data conversion

  • June 28, 2005 at 3:00 am

    #164764

    hiya,

    I have been handed an Access dbSchema that was created by someone who obviously didn't fancy attending normalisation school 🙁

    I need to:

    1) normalise the schema

    2) import the data from the un-normalised Acees schema to the normalised sqlServer schema

    I've never done this before, even in sql2k.I was wondering if yukon had any GUI tools for this.

    The main trouble is that I don't even know what the technical name of this "data + schema conversion" is..If I did, I'm sure i could google something.

    Any advice appreciated.

    yogi

  • June 28, 2005 at 4:09 am

    #568864

    Try the Table Analyser Wizard in Access - haven't used it, but looks like it targets your sort of situation.

    Regards

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • June 29, 2005 at 3:59 am

    #569249

    cheers Phil.

    Access = hassle...It took me an age to find the proplus.msi so that I could install the tableAnalyser wizard 🙁

    Anyway, i am now clunking away in Access in the hope of fixing these tables.I'm really surprised that yukon didn't supply this functionality.

    I'm glad I'm making progress though.

    much appreciated,

    yogi

     

  • June 29, 2005 at 6:35 am

    #569279

    They probabely assume that if you can use sql server, then you should be able to make a proper design...

Viewing 4 posts - 1 through 3 (of 3 total)

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