Post reply

Scripted object file names

  • June 13, 2007 at 7:51 am

    #372219

    Gah I hate the scripting in SQL 2005 SP2!

     

    ok now that that is out of the way.  The file names when you script to inidividual files are now in the format of :

    ObjectOwner.ObjectName.ObjectType.SQL

    That is a lof of junk, and I would like to get it into the format of ObjectName.SQL, and might even consider calling it like in SQL2000 where the .SQL changes to .TBL , .TRG etc.

    Anyone know of an easy way to change the file names in batches in the OS?  I could of course do it manualy, but with about 1200 tables and X numer of thousand other objects I would rather not do that.

    Any help would be greatly appreciated.

  • June 13, 2007 at 10:05 am

    #712667

    You should know by now I like to answer my own questions   Found a tool that works very well.

    http://www.surfpack.com/downloads/dir/Batch-Rename-EXE-12064-download.html

     

  • June 15, 2007 at 12:11 am

    #713146

    you might also check out this open source app I wrote for scripting objects and data from any 2000 or 2005 db:  http://www.codeplex.com/scriptdb

    it makes it easy to automate generating scripts since it's a console app, no clunky GUI like SSMS.  also it's open source so you can tweak it to your liking.

    ---------------------------------------
    elsasoft.org

  • June 15, 2007 at 5:27 am

    #713209

    Thanks! 

    Will have to take a look at it on Monday when I get back from the F-1 race at Indy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply