Administer Remote SQL Database from SQl Studio Express (Or Similar)
Posted on 2011-02-17
This maybe more of a general advice question than specific technical issue but...
Can I use Microsoft SQL Server 2008 R2 to connect to and manage a remote database (specifically a SQL 2008 database hosted by discountasp.net)
I am just trying to build some skills relevant to my workplace. Sql Server Studio 2005 is used at my work and the package seems similar, whereas the web based littleadmin program provided by discountasp is not.
In the long run, I would like to play with DTS or SISS packages as used by some of the tech guys at my work.
If it can be done, please give me a hint how to set it up, if it cannot be done, appreciate any suggestion for a good alternative that would suit my needs. As this is just a learning thing, I could even change providers if that is the best option.