Post reply

how to be SURE that data in "source" and "destination" are EXACTLY the same

  • September 2, 2005 at 5:37 am

    #74945

    hiya,

    I am importing SAGE  datafiles into sqlServer (I thought I'd mention, in case it was relevant)..

    Anyway, is there anyway to ensure that the files have been copied over exactly, date format and all? I've been looking, but I can't find anything.

    Is there any way that the DTS package can specify any columns where the data in the destination tables isn't exactly as it is in the source tables?

    Or, do I have to look at the  columns, to be sure that an exact copy was made?

    many thanks,

    yogi

  • September 5, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • September 7, 2005 at 8:44 am

    #588108

    I have no clue what SAGE is, but is there a way to reverse the process from SQL-Server to SAGE and then compare the original to what you sent back?

    In SQL-Server I use Red-Gates SQL Data Compare to see if the data is the same between two databases but I'm think that only works on SQL-Server tables.

    Steve

  • September 7, 2005 at 4:50 pm

    #588287

    hiya,

    in the meantime i found a differnt way to do what I hope I need without using DTS.

    ta for the advice though, i'm sure it'll come in handy

    yogi

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

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