I was searching for some functionality to generating database schema with existing data in Sql Server Management Studio Express. But could not find such functionality there. So, I was searching for some tool that can generate database schema with data.
Finally I've found that there is a tool - "SQL Publishing Wizard" comes with Sql Server 2005 express in Visual Studio 2008 installation dvd (I'm not sure about VS 2005). If you install SqlServer2005 express with Visual Studio 2008 installation then you can find this tool in - "C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\1.2\SqlPubWiz.exe". If this is not installed you can download it from - http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en
You can also start this tool from Visual Studio. Right click on any Data Connection from Server Explorer and select "Publish to Provider". This will start "SQL Publishing Wizard" for the selected database.
No comments:
Post a Comment