|
| Add Existing Items to Database Project |
 |
Tue, 1 Apr 2008 08:50:53 +0000 |
I created a new database project in Visual Studio 2005, and I want to add all my
existing stored procedure scripts to the project. There are roughly 2000
scripts. When I click on Add Existing Items and select all the stored procedure
scripts, it fails after 20 items have been added with the error "The
operation could not be completed. The parameter is incorrect." So I have to
go back and add the scripts in batches of 20, which takes forever. With a
database project I have not been able to find anyway to Show All Files so that I
can select to include all the scripts in the project. Does anyone know of a
patch or work around for this problem? I am certain that it is not just my
environment, as I have had this same problem on every instance I have worked on
for the last couple years. Thanks.
|
| Post Reply
|
| Re: Add Existing Items to Database Project |
 |
Tue, 1 Apr 2008 10:29:44 +0000 |
This happens with me also I hope it may VS- compatibility Problem when we are
doing some big additions...
|
| Post Reply
|
| Re: Add Existing Items to Database Project |
 |
Thu, 3 Apr 2008 15:05:28 +0000 |
I have also tried adding all the stored procedure scripts to the source control
provider (Vault) directly. But then there is still no way to refresh or get the
latest version in order to pull the files into the database project in Visual
Studio.
Any suggestions would be greatly appreciated. Is there perhaps a way to write a
custom script or macro to loop through a folder and add all the items to the
database project?
|
| Post Reply
|
| Re: Add Existing Items to Database Project |
 |
Thu, 3 Apr 2008 19:31:38 +0000 |
I finally found a work-around.
Instead of right-clicking and selecting "Add Existing Items", I just
dragged the files into the folder in the Database Project from Windows Explorer.
It added all 2000 scripts with no errors.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|