Post reply

How to change table format

  • March 12, 2007 at 1:30 am

    #177119

    Hi,

    Sub: How can i change sqlserver 2000 table format to sqlserver 2005 format?

    I have developed an application in vs.net 2005 using sqlserver 2005. This is the enhancement version to the old application which was developed in vs.net 2003 using sqlserver 2000.

    whats the problem now is, one of my customer who is using old version wants to migrate to new version. But he wants the Old database information.

    So, how can i import the old database information to new database.

    Very urgent plz.................

    regards,

    Kishore

    Kindest Regards,

    kishore

  • March 12, 2007 at 2:15 am

    #694306

    Back the database up and restore it to a 2005 server. The db will be converted during the restore. Update all the statistics afterwards, if you can.

    You should check afterwards that all the code is still working.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 12, 2007 at 3:36 am

    #694313

    Hi,

    Thanks for giving quick reply. Is this(converting) possible with query?

    regards,

    Kishore

     

    Kindest Regards,

    kishore

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

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