Wednesday, October 08, 2008
Unlike in SQL 2005, version 2000 of Microsoft SQL doesn't have SSIS 2005 to create table scripts from xsd file. In SQL 2005 you can do this by following these steps:
1. Create a new ssis projet
2. Add a data flow task
3. Add an XML source
4. From the properties, select ANY xml file as source, and select your XSD file in 'xsd location'
5. Add an OLEDB destination and link to the source.
6. From the properties, connect to a sql server database.
7. Click on NEW where it asks you to select 'table or view' and it will give you the script of the table (based on the xsd schema)
In SQL 2000 there is a workaround and it is a free online utility to convert your xsd to table script.
The site is www.codomatic.org
Here's how to do use the site:
1. From the homepage, look for the "Database Script from XSD" panel
2. Choose xsd file to convert.
3. Put your table prefix.
4. Choose the type of your db server
5. Then click "Create Database" link to start the convertion.
** if your prompt for a login, you can get a working account here
2 comments:
Thank you for this!!!!
You just saved me a lot of typing.
This is exactly what I need ( though not exactly since my db would be mysql, but Oracle SQL is close enough, I guess ).
Hi, thanks for this info
I just tried this, but the NEW button (for table) is disabled ?
am I doing something wrong ?
thanks in advance
Post a Comment