Post reply

Importing MSDE data to a sql 2000 server

  • February 3, 2005 at 9:36 am

    #102375

    HI.

    If you have an application running at a remote site using MSDE on their desktop, how would I get that data back on our sql server daily or possible periodically throughout the day?  I have no experience or knowledge of MSDE.

    thanks,

    Juanita   

     

     

     

     

  • February 3, 2005 at 11:50 am

    #540477

    MSDE is basically a pared down version of SQL Server.  Any administrative tasks that you perform on SQL Server can be performed on MSDE.  The catch is that MSDE doesn't include the administrative tools.  But, if you can see the machine that holds the database, you should be able to register it in your local copy of Enterprise Manager, and then administer it just as a full blown instance of SQL.  With that in mind, you have a number of choices for migrating the database.  If both are 2000, you can use replication, log shipping, etc.  Or, you could just take a backup of the database each day, copy it, and restore it on your local box, which will work even if the MSDE instance is 7.0.  You may be able to use log shipping if the MSDE is 7.0.  It would probably have to be a "homegrown" version of log shipping though.

    Steve

  • February 3, 2005 at 1:23 pm

    #540500

    Or you could DTS the data in at intervals.


    Shamless self promotion - read my blog http://sirsql.net

  • February 3, 2005 at 2:10 pm

    #540519

    HI. Can i install MDSE on my computer even though i have enterprise manager installed just so i can see what this msde looks like?

    juanita

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply