SQL Server Performance

XML Stored in SQL Database

Discussion in 'General DBA Questions' started by SQL2000DBA, Nov 6, 2005.

  1. SQL2000DBA New Member

    Hi,

    I need your input on pros and cons on storing XML data in SQL table.I am planning to generate XML using .NET application and store it in SQL table (column with ntext data type).Once XML data saved into DB,my .NET application reads the data and send it to web service using SOAP messaging.

    I need your feedback on what are the advantage or disadvantage in storing XML data in SQL table with data type as ntext.

    Thanks and Regards

    Ravi K
  2. satya Moderator

  3. derrickleggett New Member

    You're planning on doing this in SQL Server 2000 or 2005? If 2000, I would probably just store it in files on a file server.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.

Share This Page