April 8, 2008 at 6:18 am
Is there anyway to generate a database structure ie tables, logins, stored procs script within XML? I have looked around the web and as well as SQLServerCentral, but the search hasn't been fruitful at all. Maybe there is a tool that allows you to do that? I'm still novice with SQL2k5, so there is maybe a feature I seem to be over looking. Any help in the right direction would be appreciated. Thanks.
April 8, 2008 at 9:06 am
I haven't seen one. There are quite a few SQL Server XML functions and you might be able to read through the tables (sys.tables, etc.) and return data in XML.
April 8, 2008 at 12:27 pm
Steve Jones - Editor (4/8/2008)
I haven't seen one. There are quite a few SQL Server XML functions and you might be able to read through the tables (sys.tables, etc.) and return data in XML.
Thank you for the suggestion. I will go ahead and investigate this route. Appreciated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply