Windows Azure Connection
I'm trying to take my first steps with Windows Azure and i need to know if is possible to do what i need.
So, imagine the scenario that i've a BD on my local machine and i've a VM (Win Server 2008 with SQL Server) in Microsoft Azure.
I want to know is if is possible to connect my local DB from my VM on Azure.. i.e., Imagine that i need to implement ETL processes (Integration Services) on VM, getting data from my local BD and load it on my VM DB.
Is that possible?
Thanks in advance!
Yes, it is possible. you have to use either of:
to connect the Windows Azure VM to your on-premises network. I'd suggest to start with Windows Azure Connect as it is fairly easy to install and configure. While the latter will require a hardware VPN/firewall router.
Also pay attention to the Name resolution scenarios - you have full support for name resolution with Windows Azure Connect, while you have to provide your own DNS to use with Windows Azure VN. Note that Windows Azure Connect however provides only IPv6 Connectivity. But with the name resolution in place named pipes protocol shall be fine.
UPDATE
You can only download Windows Azure Connect from the old silverlight portal (http://windows.azure.com/). You can navigate to the old portal from upper right corner -> click on your login id, a drop down menu will appear, select "Previous portal" (the first option). Then follow the tutorials. Once you create your Azure Connect Groups, you will have the option "Download Azure Connect Agent". It is custom download per subscription, that's why there is no public download for it:
- Convert varchar list to int in Sql Server
- "č" converted to "c" when querying through SQL Server 2008
- How do I store the select column in a variable?
- Splitting Date into 2 Columns (Date + Time) in SQL
- SQL Server - Create a copy of a database table and place it in the same database?
- Cannot open backup device. Operating System error 5
- Convert string to date in SQLServer
- I want Hours,Min, second difference from two datetime
- SSRS Query execution failed for dataset
- Error restore backup SQLSERVER 2008R2 to SQLSERVER 2008
- Just added a new index, do I have to freeproccache?
- No column name showing up in SQL
- Stored procedure hangs seemingly without explanation
- Generate Dates between date ranges
- Create a temporary table with identity column
- How to load image from SQL Server into picture box?
- Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object
- Anybody using SQL Source Control from Red Gate
- How to return only the Date from a SQL Server DateTime datatype
- Cannot connect to AWS EC2 from visual studio (or anywhere actually)
- How to copy and paste script text from SSMS to Outlook or Word without garbling it?
- Is there a way to add Business Intelligence Projects templates to Visual Studio 2008?
- Update table variable
- How many triggers can be created on a table in SQL Server?
- T-SQL Change Data Capture log cleanup
- Insert into select from SQL query with both query and static values
- A connection was successfully established with the server, but then an error occurred during the pre-login handshake
- What are row, page and table locks? And when they are acquired?
- How to get the report between certain date range in Cognos
- How can I find sql server port number from windows registry?