If the date is missing, or a placeholder for a missing date, set to the Id for missing dates Create a helper function to convert dates to a YYYYMMDD format Date Id. PRINT 'Done Creating AdventureWorksDW2014 '
TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\ DATA\AdventureWorksDW2014_log.ldf ', TO N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\ DATA\AdventureWorksDW2014_Data.mdf ', PRINT 'Restoring AdventureWorksDW2012 to AdventureWorksDW2014 'įROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\ Backup\AdventureWorksDW2012.bak ' PRINT 'Deleting AdventureWorksDW2014, if it exists 'ĮXEC _delete_database_backuphistory = N'AdventureWorksDW2014 ' Delete the database AdventureWorksDW2014 if it exists.
Adventureworksdw2012 database download full#
NAME = N'AdventureWorksDW2012- Full Database Backup ', TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\ Backup\AdventureWorksDW2012.bak ' * Step 1 - Make a copy of AdventureWorksDW2012 and restore as AdventureWorksDW2014 */ PRINT 'Updating AdventureWorks2012 for Today - Starting ' * Be warned, if AdventureWorksDW2014 exists, it will be deleted as part of this process. It won 't change AdventureWorksDW2012 in anyway. This script is dependent on the AdventureWorks2012DW sample */
Adventureworksdw2012 database download update#
It will then update it for current dates. * This script will make a backup of the AdventureWorks2012DW database, then copy and restore it */ * AdventureWorks database Copyright (c) Microsoft. * Script Copyright (c) 2013 by Robert C. * Updating AdventureWorks2012 for Today */ Copy and paste into SQL Server Management Studio and it should work fine. Note some browsers don’t seem to render the script using the mono-spaced font I intend, but just ignore. I’ve now updated the script for 2014, thought I’d pass along the updated version. This will allow folks to demo date related queries and be able to simply use things like GETDATE or NOW without having to do funky math tricks to take into account the pitifully out of date offering. A while back I did a post that contained a script to update the AdventureWorksDW2012 database to have dates for the 2013 time period.
0 kommentar(er)
