SQL Server Performance

SQL Server Replication Problem with MS Access

Discussion in 'Performance Tuning for SQL Server Replication' started by manas_de45, Jul 4, 2004.

  1. manas_de45 New Member

    Hello SQL Gurus,

    I want to replicate SQL serer database with MS access database. the tables names are different in sql server and ms access but the structures are same. i cannot change the destination table name in the article. is it possible to change the destination table name in article so that i can give the names of the access tables there.

    Also there are 3 access databases. I hv created 3 linked servers for the 3 ms access databases. but data is not getting replicated.

    i hv tested it with one sql server database and 1 access database with same table names and same structure. it works fine but if the table names are diff in ms access and sql server then data is not replicated.

    Pls. help me out. this is very important for me.

    Thanks in advance,
    MD.
  2. vbkenya New Member

    In the Create Publication Wizard, at the Specify Articles screen, there is a build button [...] on the right of each article which opens a dialog box, Table Article Properties - YourTableName where you can specify the destination table name and owner.

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
  3. satya Moderator

    http://www.databasejournal.com/features/mssql/article.php/1490561 - data structures difference between MS Access & SQL server, for information.

    http://vyaskn.tripod.com/repl_ans5.htm - about setting replication between MS Access and sQL Server.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. manas_de45 New Member

    Thanks to all of you for replying.

    I tried to change the table name from the Table Article Properties but in that dialog box, the your table name is not enabled, so i didn't able to change the table name.

Share This Page