Professional Web Applications Themes

DB Syncronization - Microsoft SQL / MS SQL Server

I need to implement a procedure to Sync some database's tables from one pc to another or viceversa ... simple selecting source and destination. I don't know from what to start for my search. I don't know if SQL server has some built in utiliti, dts package. Can anyone provide some usefull links. Also ... because final use of my app is intended for make a continuosly record numeration indipendently from how many can be deleted ... I need some usefull ways to reserve an x number of records to the remote computer and align new numeration from the guest ...

  1. #1

    Default DB Syncronization

    I need to implement a procedure to Sync some database's
    tables from one pc to another or viceversa ... simple
    selecting source and destination.

    I don't know from what to start for my search. I don't know
    if SQL server has some built in utiliti, dts package.

    Can anyone provide some usefull links.

    Also ... because final use of my app is intended for make a
    continuosly record numeration indipendently from how many
    can be deleted ... I need some usefull ways to reserve an
    x number of records to the remote computer and align new
    numeration from the guest computer to the server when a
    new syncronization is done. Can this be possible in a simple
    way or is quite complicate (as I think)?

    --
    Sincerely
    Andrea Moro


    Andrea Guest

  2. #2

    Default Re: DB Syncronization

    Check the SQL Compare tool - http://www.red-gate.com/.
    I don't understand your second question.

    --
    Dejan Sarka, SQL Server MVP
    FAQ from Neil & others at: http://www.sqlserverfaq.com
    Please reply only to the newsgroups.
    PASS - the definitive, global community
    for SQL Server professionals - http://www.sqlpass.org

    "Andrea Moro" <it> wrote in message
    news:phx.gbl... 


    Dejan Guest

  3. #3

    Default Re: DB Syncronization

    Dejan ... I've bought SQL Compare, but it's intende to work as
    stand alone, or buying pro edition let y use its own api, but it's
    more expensive than my earn.

    I need something in pure T-SQL or in VB 6 code.

    Second question - sorry for poor english (may be the cause
    for which y don't understand) - I think is better comphrensible
    with a sample.

    Suppose to have Sever A in which table A has 10 record

    ID | MYCOUNTER | .....
    1 1
    12 2
    13 3
    24 4
    55 5

    and so on ....
    Mycounter must be consecutive ... always.

    Well imagine to sync two db .... now what's happen if second db
    must work disconnected from the first one ... I need to find a solution
    to reserve some MyCounter for Db2 that must intenctionally "detatched"
    from the master.

    I hope to was been more clear.

    Andrea


    Andrea Guest

  4. #4

    Default Re: DB Syncronization

    Andrea
    You can identity property to your table in order to get sequence of the rows
    Here is other way to accomplish it.

    create table temp1
    (
    col int primary key
    )

    insert into temp1 values (100)
    insert into temp1 values (200)
    insert into temp1 values (300)
    insert into temp1 values (400)

    select col,(select count(*) from temp1 t where t.col <=temp1.col)as row_id
    from temp1
    drop table temp1



    "Andrea Moro" <it> wrote in message
    news:phx.gbl... 


    Uri Guest

Similar Threads

  1. Process syncronization in perl?
    By Roy Smith in forum PERL Modules
    Replies: 0
    Last Post: November 6th, 09:10 PM
  2. Syncronization
    By Life in forum Macromedia Flash Sitedesign
    Replies: 0
    Last Post: September 20th, 09:42 AM
  3. Need help with semaphore creation/syncronization strategy.
    By Roy Smith in forum UNIX Programming
    Replies: 1
    Last Post: July 28th, 04:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139