Recent update: 2008-3-21
393 byte By
paolod at 2008-3-7
Hello everybody,perhaps a silly question, but there's a way to create a Database Project from an existing DB (e.g. Northwind :)), adding Schema Objects, and then "commit" them to the DB? If so, IMHO it should be added to creation wizard.If not, there's a "quick" way to ...
1120 byte By
noonie at 2008-3-6
Greetings,When I use Import Database Schema on an SQLServer 2000 database project (from an SQL Server 2000 database server) none of the keys, constraints or indexes are imported against the tables. They all appear to be there but are created as objects at the same level as the tables (i.e. ...
I have setup a db pro project that utilizes a Cross-Database Reference. This all works fine while in the IDE and performing a build. When I Build the project the resulting .sql file has the following inside it:...:setvar STR_DB "STR" ...Create Procedure [xyz} select distinct PMST.CML#, --s...
I wish to use VSTSForDP to support my pre-existing unit tests. Currently the process we use is anytime we make a change to the database schema we use SQL management studio to generate a script that will create the database. We then check that .sql file into TFS as a solution item. Our unit ...
455 byte By
paolod at 2008-3-3
Hello everybody,consider this scenario: I import a schema in a Database Project, then I create a table IN SQL SERVER, and I want to sync it with project.The only way I've architected till now is to create the table, script it, delete table in SQL Server, and copy the script in Database Project ...
Hello, I noticed that a project can be used as the Target Schema in a schema compare. Is there anyway to update the project with what is currently in the source database? The script that is generated is SQL meant to be run on a database and the 'Write Updates' button is greyed out. Are there ...
Error message:Object reference not set to an instance of an objectIs raised immidiately after OK has been pressed on `Import Database Schema into Database Project` dialog (Source database and Target database project is specified of course).SQL server uses Windows authentication only. User ...
I have a DB project I created by reverse engineering our production DB. VS DBPro is looking great! I have a few questions around deployment of database objects.1.) I notice that VS DBPro CTP creates one file for each object in my database project (in the "...\Schema Objects\" folder). ...
What is going to be the minimum permissions or role memberships that a DB developer will need in order to be able to import a schema from a DB into the tool? Is there a way to prevent any developer from importing the schema from a certain DB? Thanks, AW
1123 byte By
noonie at 2008-2-25
Greetings,When I use Import Database Schema on an SQLServer 2000 database project (from an SQL Server 2000 database server) none of the keys, constraints or indexes are imported against the tables. They all appear to be there but are created as objects at the same level as the tables (i.e. ...
I wish to use VSTSForDP to support my pre-existing unit tests. Currently the process we use is anytime we make a change to the database schema we use SQL management studio to generate a script that will create the database. We then check that .sql file into TFS as a solution item. Our unit ...
What is going to be the minimum permissions or role memberships that a DB developer will need in order to be able to import a schema from a DB into the tool? Is there a way to prevent any developer from importing the schema from a certain DB? Thanks, AW
After importing my schema, I see plenty of nice scripts for my sprocs and tables. I also see that my ROLES are created, but the mapping of roles to the sprocs is missing. I have a dbReader role that can access my query stored procedures and a dbWriter role that can access the ...
99 byte By
Baq at 2008-2-22
Is there a timeline available for the publication of Tutorials? Thanks, Reza.
I have downloaded the CTP and as a DBA was interested to see the functionality of the SchemaCompare and DataCompare Options. The SchemaCompare option ran great and returned very helpful results. I ran into an issue with the DataCompare feature, however. I used the same connections that had ...
On a failed deployment of the database project, I've observed that the database gets created and the deployment simply stops when the error was encountered. This is not a problem as such. However, is there any setting in visual studio that would cause the entire deployment to be rolled back ...
When I try to do an Import Database in a specific solution it consistently hangs. I have to kill the process to get it back (I've let it sit around for well over an hour). The CPU is pegged at 100%. I've tried creating a new solution with just my SQL2005 project and doing the import and it ...
I have downloaded the CTP and as a DBA was interested to see the functionality of the SchemaCompare and DataCompare Options. The SchemaCompare option ran great and returned very helpful results. I ran into an issue with the DataCompare feature, however. I used the same connections that had ...
I just started using VSTS for DP's and the first thing I noticed was after my import I have 97 errors, almost all of them due to varchar (max) not being supported. I found a bug listed for this on the connect site. What are my options here? I don't want to go and change all my fields to text ...
1048 byte By
Branch at 2008-2-17
When I try to install I get the following: [06/21/06,09:34:18] Microsoft SQL Server Management Objects Collection: f:\setup\..\wcu\RunMSI.exe exited with return value 1603[06/21/06,09:34:18] InstallReturnValue: GFN_MID XMO, 0x643[06/21/06,09:34:18] Setup.exe: ...
I am not sure where to bring up new feature requests, but figured here would work. I work a lot with Oracle and Query Plans (called Explain Plans there) and they are important in the development process to check query design and performance. I believe that SQL Server has a similar thing and it ...
I have a DB project I created by reverse engineering our production DB. VS DBPro is looking great! I have a few questions around deployment of database objects. 1.) I notice that VS DBPro CTP creates one file for each object in my database project (in the "...\Schema Objects\" ...
388 byte By
agos at 2008-2-15
Hi! Ihave project with imported schema, but on open project I give follow MessageBox: Microsoft Visual Studio Exception of type 'Microsoft.VisualStudio.TeamSystem.Data.Schema.InvalidIdentifierCriteriaException' was thrown. OK And after this message Project marked as unavailable. Project - ...
I have a SQL 2005 table with the following that I am trying to import in to my DB project:: CREATE TABLE [dbo].[Test_XML] ( [id] [uniqueidentifier] NULL, [name] [nvarchar] (50) NULL, [description] [nvarchar] (MAX) NULL, [testxml] [xml] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] I get the ...
"Data Dude" Team: I attended your sessions this week at TechEd (except the chaulk talk), and even did the Hands On lab. All-in-all, I am super impressed and can't wait to start using it against some real systems I've been working on. Great job! One thing in particular that I noticed (or ...
I'm having a problem very similar to the one posted by Daniel Pratt a few days ago.Steps:--Created an sql2k project.--Imported schema.--Fixed about 270 double-quote-to-single-quote errors.--Upon having a clean project, save and close.--Reopening takes a long, long time (probably around 15-20 ...
981 byte By
paolod at 2008-2-14
Hello everybody,I just finished and review for Database Professionals.Very interesting features are "inherited" from Visual Studio Team System: change control and work item tracking, unit testing (very good!), refactoring, and also parallel execution of T-SQL queries.About specifing features, ...
Do we have the ability to invoke the data generator from the command line or as a part of the deployment of the database (i.e. using the Deploy Selection command)? This would be useful in automated build setups where we need to perform some sort of intermediate check after a successful creation ...
201 byte By
paolod at 2008-2-13
Hello everybody, can a Data Generator Plan be used just for testing? No possibility one can use it to immediately generate data in SQL Server, e.g. as a checkbox choose on Deploy Selection?
159 byte By
paolod at 2008-2-13
Hello everybody, it's a GREAT feature I can create a random text field using a Regular Expression, but.... HOW can I specify a regular expression?
456 byte By
paolod at 2008-2-12
Hello everybody,consider this scenario: I import a schema in a Database Project, then I create a table IN SQL SERVER, and I want to sync it with project.The only way I've architected till now is to create the table, script it, delete table in SQL Server, and copy the script in Database Project ...
When using the data generator, the the data generation preview tool window within Visual studio shows gibberish text for a varchar or a nvarchar column, the generator being set to string. Is there a setting that i'm missing ? I have not made any specific setting - just added a data generation ...
219 byte By
paolod at 2008-2-10
Hello everybody, IMHO list of test conditions for a Database Unit Test is too restricted, and of course I'd like to customize both list itself, and parameters in existing conditions. Is there any way to do it?
394 byte By
paolod at 2008-2-10
Hello everybody,perhaps a silly question, but there's a way to create a Database Project from an existing DB (e.g. Northwind :)), adding Schema Objects, and then "commit" them to the DB? If so, IMHO it should be added to creation wizard.If not, there's a "quick" way to ...
Made in notepad as I was playing with the product... In data generation plan, there is no way to "Select All" or "Unselect All". Even support of CTRL-A would be nice. Can't copy and paste values out of the Data Generation Preview. Changing "Rows to insert" ...
As of subject. It would be simply marvellous....
125 byte By
paolod at 2008-2-7
Hello everybody, did you note when you rename a stored procedure, and then open it, old name is displayed in tab?
As of subject.
189 byte By
paolod at 2008-2-7
Hello everybody, I noted CTP3 setup installs two additional components. First is SMO (but why "Collections"?), but what is "Visual Studio ProjectAggregator"?
Since yesterday night the Connect site has the new Visual Studio version so we can now use it to provide feedback. However afaik there's no quick way to find feedbacks only for Visual Studio for DB Pros, I suggest we use a convention in the title, something like "problem bla bla bla in ...
601 byte By
Tobi at 2008-2-6
I'm geting the following error after importing, the view works but can't find a reference to the function which has aslo imported correctly. The function is question has red ! icon against it. In most of the object have red ! icons. Error 1 Cannot find either column "dbo" or the ...
I see there are a couple posts from people dealing with an "object reference not set" error. I'm getting the same error, but in a different circumstance. I... created a new SQL Server 2000 database project imported schema from a SQL Server 2000 database closed and saved the project ...
1445 byte By
Dale at 2008-2-5
When deploying the database project, you should have the option to select where to deploy at that time. Currently, the selection is made at the project scope. It is very common in my usage even so far to deploy a database to more than one location. I may create a database model and deploy it ...
88 byte By
Dale at 2008-2-5
Is there a bug tracking site for the Database Professionals version? Dale
778 byte By
Dale at 2008-2-4
I think there is some opportunity for improvement in the location of options and settings. For making schema comparisons, the option to ignore various features of the database are set in the application scope Tools->Options area. This doesn't make much sense to me. While you could set ...
When I imported the database, some of the foreign key constraints generated errors stating that: Error 4 Path for file C:\Documents and Settings\fritcheygr\My Documents\Visual Studio 2005\Projects\BoundBooked\BoundBooked\BoundBooked\Schema ...
I really would like to use this tool, but when I try to import a database, all I get is the error message "Object reference not set to an instance of an object." I'm working on a 2000 database (sp3a if that matters) where I have sysadmin privileges. I just don't understand why ...
335 byte By
Tobi at 2008-2-4
Hi, I have been tryng to import a database schema to a project which has about 3000 objects (tables, sp's, functions etc) it's taking ages (over 20 minutes and still waiting). The first attempt failed, are there any logs I can look at / switch on to see if there are any problems with the ...
Firstly, nice to see such a product as VSTSDBpro from Microsoft, can't wait until it is offically released. Is there any way of using the product without having SQL Express? I would like to try the CTP on a pure SQL 2000 environment and was hoping there would be a way of configuring it to ...
Hi, Do you have any plan to support Oracle and DB2? Or is there any extension point to write plugins for other databases? Thanks.