Russ Johnson January 27, 2007
4:53 PM 5 Comments

MSSQL Export Question

I am in the process of finalizing the first release of Trac_Fu and something just occurred to me. During exporting the database scripts for SQLServer, I have no option for including INSERT statements for the default data.

I use PHPMyAdmin to export my MySQL scripts and I can include inserts for all of the default data that goes with the database. But when looking through the SQLManager 2005 client, I cant find anywhere to allow me to add the inserts, it only generates the scripts for the database objects themselves. I guess I've never really had a need for this feature on any application that I've built for MSSQL before.

My question is what tools to do you guys use for exporting your MSSQL databases with data into scripts?

I just realized that the default scripts that the 2005 client generates will not run in MSSQL 2000 either. I guess Im going to need a third party tool to export the MSSQL scripts so they will run on either version.

Let me know what you guys are using currently.

Print | Send | del.icio.us | Digg It! | Linking Blogs | 2147 Views

Feel free to Leave a Comment or just read what others have to say

5 Comments so far

  1. todd sharp 1/27/07 9:18 PM
    todd sharp's Gravatar Check out this post http://weblogs.asp.net/scottgu/archive/2006/12/22/...

    I bookmarked it awhile back with the intention or reading it to address the same issue you are having.

    By the way - this text in the comment area is the smallest friggin text I've ever seen in my life. Its unreadable!!!
  2. Collin 1/27/07 11:15 PM
    Collin's Gravatar This may also be useful:

    http://www.robgonda.com/blog/index.cfm/2006/12/4/S...

    Looking forward to seeing the results!
  3. tony petruzzi 1/28/07 2:35 AM
    tony petruzzi's Gravatar Personally all I do is use the export wizard and export it into a tab seperated file. This make it very easy to import into any database. All database platforms have some sort of import wizard that will take a tab separated or comma separate value file. It is also good if you want to open the exported file in Excel or your favorite text editor and edit or look over the data. Also good as a poorman's back.

    @todd

    Remember that in FireFox, CTRL+ is your friend :) It will enlarge the text. Use CTRL- to decrease the size of the text.
  4. Dan Wilson 5/21/07 9:59 AM
    Dan Wilson's Gravatar @Russ,

    The Sql Script Builder tool has great multi-database support. It will generate scripts from pretty much any database including MSSQL Server, Oracle, MySql and Postgres (newly added).

    What I like most about this tool is I can generate a MSSQL database from a MySql database. Sql Script Builder is also free, which is nice. Maybe give it a test drive?

    Here is the link for the application:

    http://www.sqlscriptbuilder.com/

    Dan Wilson
  5. Andrew 8/2/07 4:04 PM
    Andrew's Gravatar Oh! I had such a question and forund an answer here :)
    Thank you for posts and links.

    ___
    http://thebirdhouses.biz

You may Leave a Comment