Nov 14, 2008 #1 ifmo114 Programmer Feb 27, 2002 15 US Does anyone have any tips on creating a single XSD file for a SQL Server database with many tables? Thanks.
Does anyone have any tips on creating a single XSD file for a SQL Server database with many tables? Thanks.
Nov 14, 2008 #2 hwkranger MIS Nov 6, 2002 717 US Open Business Intelligence Studio. Open the Server Explorer Open a new file for XML Schema Hold SHIFT + CTRL and HIGHLIGHT ever table in the Server Explorer Drag Onto your visual XSD Designer It's uber slow, but now you're done. I also bet this isn't what you want -- but take a stab. Upvote 0 Downvote
Open Business Intelligence Studio. Open the Server Explorer Open a new file for XML Schema Hold SHIFT + CTRL and HIGHLIGHT ever table in the Server Explorer Drag Onto your visual XSD Designer It's uber slow, but now you're done. I also bet this isn't what you want -- but take a stab.