![]() ![]() When he just grabbed the mdf file and tried to create the database using the attach_rebuild_log option it came out corrupted. He had some issues with the version of AdventureWorksDW2012 located at. A friend and co-worker, Bradley Ball ( | blog ) pointed out one issue which I’ll pass along. First, you will need to have AdventureWorksDW2012 installed on your system. The script, below, turned out to be pretty simple.īefore you begin though, a few prerequisites. Below is a script which will add five years to each date in AdventureWorksDW2012. ![]() I scoured the search engines but couldn’t find anyone who had taken time to come up with a way to update the database. This script is for the Data Warehouse version, AdventureWorks DW2012. This is especially irritating when demonstrating features reliant on the current date ( think GETDATE() or NOW() ).īefore you read further, let me stress again this is NOT for the typical AdventureWorks2012 database. I think you’d agree though it’s gotten a little long in the tooth. Being a BI guy, I specifically use the AdventureWorksDW2012 version, the Data Warehouse of Adventure Works. Like many of my fellow MVPs and Presenters, I use the Adventure Works sample data from Microsoft to do my presentations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |