Register
Sunday, February 05, 2012
 
 DBAs And ProgrammersBlog
  
News! Minimize
   
 
 Print   
 
Misc Blog Stuff Minimize
   
 
 Print   
 
The Reluctant DBA Minimize
 
 
 
 Print   
 
Reluctant DBA Minimize
   
 
  
 
Reluctant DBA Minimize
   
 
  
 
The Reluctant DBA Minimize
 
Nov18

Written by:CarpDeus
11/18/2008 10:10 PM 

I've been working with SQL Data Services and that requires some data to use. Here is a zip file that contains both the XML and a command file that you can use with the SQL [Server] Data Services Import/Export tool to load the data into your own instance. The easiest way to do this is to set up a container named calendar-of-events using Mike Amundsen's S[S]DS Provisioning Client. Then you can run the command file with parameters:

LoadCalendarData Authority User Password

This will load 241 holiday dates for 8 separate web site ids. To test everything is loaded, you can use the following query in the Entity Query on Mike's site:

from e in entities where e["WebSiteID"]=="W8" select e

That should get you 241 entries, numbered 1688-1928.

Enjoy


This particular task took me longer than it should have because I was using everyone's favorite database, Microsoft Excel, to create the XML file. I had the data for WebSiteID=1 and decided it would  be quick to just load that into Excel and then copy it and do a little formula jiggery-pokery to get the updated values. Unfortunately, I didn't take into account the header row and it took me 45 minutes to figure out why the data was not loading...

Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment  Cancel 
 
 
  
 
Privacy Statement | Terms Of Use Copyright 2001-2008 by ReluctantDBA.com