You are browsing archives for
I’ve been working on migrating existing SQL Server database projects into Visual Studio for Database Professional projects. Most of the existing databases have imported without major problems, but there are a few that have warnings about cross-database joins in old unit tests. TSD3025: The following cross-database dependencies could not be verified: … Your database application […]
I just handed a work mate an output script from DataDude, which he ran in Management Studio. Instead of producing the expected database he ended up with one called $(DatabaseName) Remember database pro uses SQLCMD to deploy databases If you use Management Studio to run an output script, you’ll need to swap into SQLCMD mode […]
I’ve been migrating unit tests to a new Visual Studio Database Professionals project. So far there’s been no problems (other than trying to find a naming standard). This problem had me scratching my head for a few minutes today. I defined a unit test for a stored procedure as: DECLARE @ItemCode varchar(32), @PriceLevel varchar(32) SELECT […]
Michael Hunter (a.k.a The Braidy Tester) has posted another useful article posing the question: "Do you even need to test your product?" After covering [story:vstsdbpro-five-point-testing] its interesting to see some expanded ideas on why you might choose not to test an application. Some of these things are obvious. But with an over-eager developer/tester on the […]
Now that Microsoft have released Visual Studio Team Suite for Database Professionals (aka [story:datadude]) its time for SQL Server developers and dbas to learn more about Unit Testing. There is many different methods to test a database within the framework set by Visual Studio. So how do you know which way is best? Well one […]
Sachin has just published a draft whitepaper on database unit testing using Team Edition for Database Professionals. The whitepaper includes details steps on creating your first unit test; automatic test generation; the standard test conditions available; and even delves briefly into the C#/VB.Net code used by the testing framework. I highly recommend users of Database […]
There has been a lot of discussion in the forums about which track of Visual Studio is required for the new Database Professionals (Data Dude) Trial to install. Database Professionals TRIAL requires Visual Studio 2005 Team Suite to be installed. A Visual Studio Team Edition for Database Professionals will be available as a standalone product […]
MSDN Downloads updated this morning with the release of Database Professional aka “Data Dude”. Download the 20MB trial from here which is really a full version if you have a full license of Team Suite already installed. The development manager explains the difference between the full DVD download and the trial: The full product download […]
Changing the comparison rules for the Data Compare is not as obvious as it should be. You need to go into the Tools -> Options menu to make changes. Click on the Tools Menu -> Options Expand Database Tools in the tree Select Data Compare. I’m waiting to see if this has changed in v1.0, […]
Changing the comparison rules for the Schema Compare is not as obvious as it should be. You need to go into the Tools -> Options menu to make changes. Click on the Tools Menu -> Options Expand Database Tools in the tree Select Schema Compare. I’m waiting to see if this has changed in v1.0, […]
![What with this database called [$(DatabaseName)] ?](https://www.julian-kuiters.id.au/images/articles/xdbpro-databasename-sqlcmd_1.PNG.pagespeed.ic.Ed6C4piwC_.png)
