Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL Database Migration Question

  • 20-03-2011 5:37pm
    #1
    justindublin
    Registered Users, Registered Users 2 Posts: 345 ✭✭


    Hey Guys,

    So I promised I'd help with my brothers move to a new POS system and regretting it horribly now lol Hopefully someone can help...

    From his old system I’ve managed to export his entire transaction history as an XML table and need to try get it into the new SQL Database.

    There are two columns in the XML I need: TRANSACTION and AMOUNT.

    Now in my new database I have a table with two very similar columns, only with different headers/names: TRANS and TOTAL.

    Now everything from TRANSACTIONID has already been dumped into TRANS.
    I just need now to import the AMOUNTS into the TOTAL column, while matching it with the correct TRANS

    Is there any simple way of doing this or should I been posting this on elance or buying someone a pint lol? :pac:

    Appreciate any help lads! :)


Comments

  • #2
    spcw
    Registered Users, Registered Users 2 Posts: 199 ✭✭spcw


    import the XML to excel and the use SQL manager to import that data as a table in your database


  • #3
    amen
    Registered Users, Registered Users 2 Posts: 2,781 ✭✭✭amen


    are you moving from one SQL database to another ?

    if so why not backup the db on the old one and restore to the new one?

    you could also use bcp which copies the data to a sql format file which you can then reimport.

    Its a bit worrying though that your POS provider has chosen to use a SQL keyword for a column.


  • #4
    justindublin
    Registered Users, Registered Users 2 Posts: 345 ✭✭justindublin


    spcw wrote: »
    import the XML to excel and the use SQL manager to import that data as a table in your database

    Okay I have SQL manager now, brilliant piece of software.

    The tricky bit now is importing the data to the correct rows.
    Taking SQL outta the equation now...

    I have two excel sheets.
    One has Transaction ID's and Amounts.
    The other just has Transaction ID's.

    Is there a way I can run something to import the correct Amounts to the matching Transaction ID's?


Advertisement