Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to create 4-5 REMOTE SQL servers for a learning purposes. I want to avoid all installation, admin, troubleshooting tasks. I want all this FOR FREE.

How do I do this ?

The purpose behind creating these servers is to pull a few tables from the 4-5 servers and put them into another remote server.

share|improve this question
You're obviously aware that setting up servers involves "installation, admin, troubleshooting tasks", not to mention actual hardware and software costs. Why do you expect to get all this for free? – Pondlife 9 hours ago
@Pondlife - For learning some features of SSIS. Don't have access to mulitple servers with some DB to practice what I want to do. Is it possible to run 3-4 VMs on my system and SS inside those and make it look like different servers to my host OS ? – etl dude 7 hours ago
The simplest approach is probably to install multiple instances on one server. Each one is an independent instance of SQL Server so they can all be configured differently, you can stop and start them separately, you can create linked servers between them etc. SQL Express is free, or Developer Edition is cheap (and included in an MSDN subscription) and has all the features of Enterprise Edition. Of course you need hardware capable of running the instances and you may need to restrict their memory usage. – Pondlife 7 hours ago

1 Answer

up vote 0 down vote

You can add remote sql server within same network using the LinkedServer concept

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.