locked
Online to Offline application RRS feed

  • Question

  • Hi everyone, 

    I want to change an On-line application to off-line application.
    The on-line application is using  large number of tables,stored procedure,views.

    I want to make only one module to work in off-line.
    So I want to sync the tables that are related with that module, from server DB to client DB vice versa.
    server DB: SQL server 2005
    Client DB:SQL Express edition

    Inorder to find the tables related with that module I looked SQL profiler.
    Profiler is producing large number of results.

    Its taking too much time to find the tables that are related to that particular module.
    Because I have to go through all the stored procedure,views to find the tables.

    Is there any other way to find the tables related with that module?


    Thanks, Bharathi
    • Moved by Max Wang_1983 Thursday, April 21, 2011 10:36 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    Saturday, November 14, 2009 5:10 PM

Answers

  • Hi Bharati,
      As I undertand you are making part of your online  application move to offline mode.  It will helpful if you can give more details on what you mean by module of the application.  It seems it is specific to your application design.
    From your description, gathering scope information (tables/sp) for a given module inside your app will depend on how you define your module.


    thanks
    Jandeep
    jandeepc
    Thursday, November 19, 2009 8:02 PM