Is there a software for sql server export xml freeware so I could bypass BCP and FOR XML Syntax? Need to export some .xml files.
EMS Data Export for SQL Server is the software that you need to export XML a powerful tool to export SQL Server database data quickly to any of 19 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF, ODF and others. The program supports Unicode data and has the ability to export SQL Server data from several tables, views or queries at the same time.
To download it:http://ems-data-export-2007-for-sql-server.software.informer.com/download/
