locked
Table Structure RRS feed

  • Question

  • User-1031608939 posted

    Hi,

    Is it possible to copy table structure & data from sql server 2008 to sql server 2003? I only found it is can copy data instead of structure and data together.

    Please advice.

    Thanks.

    Regards,

    ling

    Sunday, July 24, 2011 9:33 PM

Answers

All replies

  • User896700311 posted

    Hi,

    sure, only do this article explains:

    http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx

    in the fourth image, additinally modify the option... compatibility for SQL SERVER 2005

    Any dubt, post your comment.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, July 24, 2011 9:39 PM
  • User77042963 posted

    You can  generate both data and table structure script  from SSMS 2008.

    Sunday, July 24, 2011 9:43 PM
  • User-484744148 posted

    Hi,

    Is it possible to copy table structure & data from sql server 2008 to sql server 2003?

    I don't think there is a 2003 version of SQL Server.

    Anyway yes it is possible.

    Run the SQL Server Import and Export Wizard.

    This tool is very powerful. It will include the schemas when you import the data.

    See link. http://msdn.microsoft.com/en-us/library/ms140052.aspx

    Hope this helps.

    Regards,

    Sgt. 8log

    Sunday, July 24, 2011 9:59 PM
  • User-1031608939 posted

    Hi,

    It should be 2000 instead of 2003.

    Answer is can but I found sql server 2008 support certain data type which sql server 2000 not support. Thus, cause a bit difficulties to transfer table structure & data across.

    Thanks.

    Regards,

    ling

    Monday, July 25, 2011 2:10 AM