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