export data into insert statements

is there any tools to do so? export everything into a lot of insert statements. i mean those free tools or scripts:)What are you trying to do ?|||it is for my web-based application, which checks database version to determine whether it is valid. if not valid, just execute all pre-defined sql scripts. can help customers to install the web-based application.|||This link may help you:
http://www.red-gate.com/SQL_Compare.htm
But it's not free stuff...|||Thanks guys. Just found a tool from msdn web site: sqlwebadmin. a bit similar to phpmyadmin. can export everything into scripts. but it got problem with large database. but at least can use:)|||Did you mean you wanted to script your database - creating the database, tables, constraints ... If so, then you can script it through Enterprise Manager.|||Em doesn't script data.|||For those of you who want to download this tool:

tool (http://www.microsoft.com/downloads/details.aspx?familyid=f0d03472-5e6c-459e-a6d8-6745a729c3c9&languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylang=en)

Export data from SQL2000 to XML

How can I export data from SQL2000 to XML?
Is there any tools with SQL for that?
I don't want to use "for xml explicit"...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi

Check out:
http://sqlxml.org/faqs.aspx?faq=10
http://sqlxml.org/faqs.aspx?faq=29

John

"Leszek Gruszka" <leszek.gruszka@.kana.com.pl> wrote in message
news:415bfe97$0$26155$c397aba@.news.newsgroups.ws.. .
> How can I export data from SQL2000 to XML?
> Is there any tools with SQL for that?
> I don't want to use "for xml explicit"...
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!