Sunday, February 19, 2012

Database projects in VS 2005

Iam trying to create a database project using VS 2005 for a database existin
g
in SQL Server 2000. As per MSDN right clicking the tables in server explorer
should show a "Generate SQL Script " dialog ... but Iam not able to see this
... Am I missing some installation/tools ?
-SenthilIn the right-click menu, there is a "Script table as..." with submenus.
In the Server Explorer, you have to right-click on a specific object,
not the tables "folder".
However, you can select multiple tables and script them from the Tables
Summary window. Select the Tables folder and hit F7 to bring it up.
Senthil wrote:
> Iam trying to create a database project using VS 2005 for a database exist
ing
> in SQL Server 2000. As per MSDN right clicking the tables in server explor
er
> should show a "Generate SQL Script " dialog ... but Iam not able to see th
is
> ... Am I missing some installation/tools ?
> -Senthil
>|||There is no "Script Table As..." menu option ' Again Iam using VS2005.
-Senthil
"Trey Walpole" wrote:

> In the right-click menu, there is a "Script table as..." with submenus.
> In the Server Explorer, you have to right-click on a specific object,
> not the tables "folder".
> However, you can select multiple tables and script them from the Tables
> Summary window. Select the Tables folder and hit F7 to bring it up.
>
> Senthil wrote:
>

No comments:

Post a Comment