Pulling Multiple Tables using RDA.Pull

Posted on 2007-07-31
Last Modified: 2013-12-05
What is the best way to pull multiple tables from a SQL Server Express database into a CE device using RDA.Pull ?

Currently I am using the following code for every table:
rda.Pull("table_name", "Select * from table_name" _
                 rdaOleDbConnectString, _
                 RdaTrackOption.TrackingOnWithIndexes, _

But there are about 10 tables, and I'm thinking that maybe this is slow and there is a faster way of doing it? Is it posslbe to pull the whole database in one go? Thanks.
Question by:marjog
    LVL 14

    Expert Comment

    afaik, you have to pull tables individually.
    LVL 48

    Accepted Solution

    It can pull selected columns from multiple tables into a single table when using the TrackingOff option

    Featured Post

    Are your corporate email signatures appalling?

    Is it scary how unprofessional your email signatures look? Do users create their own terrible designs and give themselves stupid job titles? You can make this a lot easier for yourself by choosing an email signature management solution from Exclaimer today.

    Join & Write a Comment

    A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now