Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: RESTORE SQL Server to msde?

    Is it possible?

    How about all dev in sql server then migrate to "production msde" using either DTS or bcp and DDL scripts?

    Can you bcp in to msde? And is msde true client server?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    MSDE is the desktop version of SQL Server. It is limited in terms of only 2 Gb per database, and only 5 simultaneous active spids per instance, but those are the only significant limitations.

    I don't remember if BCP is included in the executables, although OSQL.EXE definitely is. The Transact-SQL BULK INSERT command works just fine, and is simply a different interface to the same API that BCP uses.

    DTS works on an MSDE instance without any reservations that I know of, other than the limitations imposed by MSDE itself.

    -PatP

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Cool...so if they want this application to be distributable...should be no problem...right?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    No problem I can see. Don't overlook the easy answer if you can just detach the database and zip it though!

    -PatP

Posting Permissions

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