Results 1 to 6 of 6

Thread: SQL CE to SQL Server Transfer..

Hybrid View

  1. Mar 19th, 2010, 02:38 AM #1
    rothj0hn
    rothj0hn is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2006
    Posts
    398

    Re: SQL CE to SQL Server Transfer..

    Thanks Pete..
    Reply With Quote Reply With Quote
  2. Apr 12th, 2010, 10:27 AM #2
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: SQL CE to SQL Server Transfer..

    We create VIEW in MS SQL SERVER that "respect" the simpler datatypes in SQL CE and we have a general routine that "reads" the schema of the views and makes those tables in the SQL CE database.

    That's a really simple way to achieve at least one-way direction.

    For write back to the MS SQL SERVER from the PPC we have a dirty flag we set in the SQL CE tables that allows us to run SERVER-SIDE SPROCS from the PPC for "the other direction".

    Do you leave with a copy of SERVER-SIDE data that can be updated in 100% of all the ways possible on the PPC?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width