Monday, March 26, 2012

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)

No comments:

Post a Comment