<< October 2006 >>
Sun Mon Tue Wed Thu Fri Sat
01 02 03 04 05 06 07
08 09 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31



Technology Thoughts, ramblings.. etc

If you want to be updated on this weblog Enter your email here:



rss feed



Tuesday, October 17, 2006
New SQL Utility

Hi,

There is a new SQL utility published on the Microsoft downloads' site:

http://www.microsoft.com/downloads/details.aspx?familyid=16d8c1e9-a6a3-43a2-9ba7-916c6eb5023b&displaylang=en

It allows the scripting of a database which includes both scripting of the schema as well as scripting the data!  Well worth a look as it could be beneficial in a build process or backup.

I've instaleld it but I haven't had time to see how well it works.  I'm curious as to how it works, whether it uses COM or SMO or DMO or some combination.  If you take a look at it, please leave feedback on it or it's uses here on this post.

Until next post,

Rob

Update:
 
Error: [dbo].[tablename], column 'columnname' is of type [UserDefinedDataTy
pe].  This type is currently not supported.
 

Damn!  No support for UDTs!

(Items in Red have been sanitised for your enjoyment)


Posted at 01:50 pm by ausrob2003

 

Leave a Comment:

Name


Homepage (optional)


Comments




Previous Entry Home Next Entry