recently i came to know that i can use Visual Interdev's database project facility to work with my SQL Server's databases.. .. .having tried with the same, i created a vss and a database project also. . .. but i am not being able to provide a source control for my database project.. . . i hope someone's been using this.. . .and i can imagine how wonderful it will be using check in and check outs directly into the vss . . .no versioning problems. ..
can anyone help with the same and tell how to go about it ... . ..
Thanks . .It will be similar to VB. BUt most imp thing is ur interde should be connected to server for a database project.
Showing posts with label projects. Show all posts
Showing posts with label projects. Show all posts
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:
>
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:
>
Subscribe to:
Posts (Atom)