Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Posts
    28

    Unanswered: Restoring db's between instances with different sort orders in SQL 7

    Developers created their own instance on a test box, but our prod. servers use a different sort order - case sensitive, binary order. Is there any way I can force a restore of their user db's from their test box to our prod. server?

    NT4, SQL 7.0

    Thanks...

  2. #2
    Join Date
    Dec 2002
    Posts
    28
    bump...please, any advice would be helpful. still fairly new to SQL Server, and I was thinking there'd be a way to do this using SQL as opposed to another utility.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by crafuse
    bump...please, any advice would be helpful
    shoot the developers?
    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.

  4. #4
    Join Date
    Dec 2002
    Posts
    28

    Wink

    LOL...

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Seriously though...I don't think you can...

    Why do developers have to get cute and mess around?

    For the most part, every book usually indicates to use the default install...

    There are always exceptions...none I'm sure the devlopers could come up with...
    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.

  6. #6
    Join Date
    Dec 2002
    Posts
    28
    I kinda figured this couldn't be done, at least not using the db engine. So, off to rebuild their box...

    Not actually their fault - they used the default install, but it's the prod. servers that use some unusual install config settings. And these developers are an outside crowd, so the blame I guess is our own.

    Thanks for the help Brett.

    Chris

Posting Permissions

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