Comments
rock333 wrote: At the IaaS Cloud layer virtualisation is going to be essential to allow the self service attributes, all painful and slow to do with physical hardware. Moving up the stack to PaaS and SaaS the use of virtualisation may, as you say, be less required if you put lots of smarts into your software. A lot of software does not have those smarts and by utalising virtualisation of the layers below can manipulate existing software architectures to have more cloudy attributes through automation (eg run load balancers and deploy more servers automagically). Over time, as new investment in software at...
Cloud Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..


2008 West
DIAMOND SPONSOR:
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
PLATINUM SPONSORS:
Red Hat
The Opening of Virtualization
GOLD SPONSORS:
Appsense
User Environment Management – The Third Layer of the Desktop
Cordys
Cloud Computing for Business Agility
EMC
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Intel
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Sensedia
Return on Assests: Bringing Visibility to your SOA Strategy
Symantec
Managing Hybrid Endpoint Environments
VMWare
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
PLATINUM SPONSORS:
Appcelerator
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
GOLD SPONSORS:
ICEsoft
How Can AJAX Improve Homeland Security?
Isomorphic
Beyond Widgets: What a RIA Platform Should Offer
Oracle
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts

Now more than every there is pressure on IT to offer higher levels of service and a greater degree of availability all while cutting back on costs. As such, making sure your technology environment is efficient and effectively managed is absolutely essential. The data center, by its very nature, i...

SYS-CON.TV
SQL Azure and MS SQL Server Integration Services
Enterprise data can be of very different kinds ranging from flat files to data stored in relational databases and XML datasource

Enterprise data can be of very different kinds ranging from flat files to data stored in relational databases and XML datasources. The extraordinary number of database related products, and their historic evolution, makes this task exacting. The entry of cloud computing has brought area into the forefront as SSIS has been one of the methods indicated for bringing ground based data to cloud storage in SQL Azure, the next milestone in Microsoft Data Management. Presently the following methods are indicated:

  • Run Insert statements SQL Manager to populate tables schema created using SQL Azure MW*
  • Configure SSIS to bring in data
  • BCP [perhaps in next CTP of SQL Azure]
The first method works and can be very fast (only a small table was tested )

It may be noted that SSIS is another tool to bring in tables (so far only tried this object in the initial tests) to SQL Azure although only table schema is migrated and not the data. If the table were to have a clustered index, data porting may also be possible. In the test conducted the table did not even have a primary key column.

* It appears that the recent tweaking of SQL Azure MW can bring in the entire database according to a posting on the Oakleaf Systems blog site.



Read the original blog entry...

About Jayaram Krishnaswamy
Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His recent book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. He writes articles on several topics to many sites.

SOA World Latest Stories
Cloud Computing Journal caught up with the CEO of a major new player in the fast-emerging Cloud ecosystem - a CEO who has taken an interesting and unusual decision. While signing up as the Platinum Plus Sponsor of the 5th International Cloud Expo, he and his company have decided to rem...
Novell broke its 18-day silence late Saturday morning and rejected the unsolicited $5.75-a-share offer to take the company private that Elliott Associates plunked on the table March 2. Novell wants more money. Bearing in mind that Novell currently has close to a billion dollars i...
NaviCloud is a next-generation platform that combines the economic efficiencies of cloud computing with true enterprise-class reliability and security. With built-in high-availability, a state of the art operations center, and a highly resilient service delivery infrastructure spanning...
Dell is suing Sharp, Hitachi, Toshiba, Seiko Epson and HannStar in district court in San Francisco for fixing the price of LCDs and overcharging since 1996. It wants treble damages. Bloomberg repeats the suit’s observation that Sharp and Hitachi admitted overcharging Dell in a plea agr...
SYS-CON Events announced today that VirtuDataCenter, a cloud computing network infrastructure company, will offer a complete turnkey alternative to today’s cloud computing solutions. They will exhibit at SYS-CON's 5th International Cloud Expo (www.CloudComputingExpo.com), which will ta...
A reconstituted SGI has resurrected its old entry-level enterprise-oriented Origin brand and slapped it on a Westmere-EP Xeon 5600-based SME-targeted workgroup blade system called the Origin 400 that comes with integrated SAN and networking. The thing, which is made for standard busi...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021


SYS-CON Featured Whitepapers
ADS BY GOOGLE