Daniel Fisher (lennybacon.com)

SOA, DATA & THE WEB

Data generation is at best done with tools. Since Visual Studio Data Tools have dropped support there is for instance red gate’s DBA bundle. My current license does not work with Microsoft SQL Server 2014. I need a quick solution to reproduce a scenario with *some more data* in just one table. Which means I already have some data in the table. So I wrote the following TSQL script to help me out. Just clone the Table schema, define the upper limit and multiply the data by running it.

Oder warum sollten sich mehrere Anwendungen nicht dieselbe Datenbank teilen?

I have a test environment for an application. From time to time I take the database to my local development environment.

I have a test environment for an application. From time to time I take the database to my local development environment.