I've a SQL Server database on a web server. As I changed my hosting company I would like to transfer the database to the new server. What is the best way to do this? Can it be done using Visual Studio? Both connection are available on my VS Server Explorer. Is it possible to transfer the tables from one connection to the other?
user mapping need to be fixed if take a backup from sql server 2000 and restore it in 2005. I have also written small article and script for the same at my blog.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…