SQL2008R2 to SQL 2005

  • Hi,

    I am a new bie to sql 2008 .

    I have SQL 2008R2 express edition with advanced services on 1 server. there i have a table.

    I want it to export it to sql server 2005 enterprise edition on other server.

    Is it possible,

    If yes, then how.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • Table or database?

    If database, what was wrong with all the answers you got last time you asked this? Specifically the first reply that stated how this needs to be done.

    http://www.sqlservercentral.com/Forums/Topic1052465-1292-1.aspx

    If you need more details, please ask, but the general question was answered.

    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
  • I need just 1 table

    Regards
    Sushant Kumar
    MCTS,MCP

  • Does it have any SQL 2008-specific data types?

    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
  • no.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • nvarchar(max) i guess its used in sql 2005 also.

    not sure thou

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • The new data types are listed at the beginning of this: http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008-the-new-data-types/

    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

Viewing 7 posts - 1 through 6 (of 6 total)

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