Migrating SQL Server in-house from outsourced company

MS SQL SERVER

    Sponsored Links

    Next

  • 1. Where is the path to the "Current Settings" file stored for SQL 20
    I want to redirect the settings file for SQL Mgt Studio so that it is stored on my local drive instead of the nework. I haven't been able to find the string in either the registry or in the Tools>Options menu like it is in Visual Studio. Thanks in advance for the pointer. -- John Shahan
  • 2. Advance Hardware Configuration/Tuneups
    Hi - I am wondering if anyone of you can point me to the right direction. I am looking for advance comprehensive hardware (also for clusters if possible) server configuration for datacenters. What book/resource do you think is the best? I will appreciate any response. Thanks!!!
  • 3. SQL Server 2005 Enterprise License Question
    Hi, We've installed SQL Server 2005 Enterprise - downloaded via an MSDN subscription - on a development server box. We now wish to utilise the server hardware in a production environment (it is also a web server which will host a live company Intranet). Do we need to uninstall the MSDN version of SQL Server and install a new retail version, or is there a way to upgrade the MSDN version? We have Volume Licensing. Yours, confused.

Migrating SQL Server in-house from outsourced company

Postby Bil » Sat, 07 Aug 2004 10:34:17 GMT

Hi

I am looking for some advice. My company currently outsources the hosting
and administration of our databases to a third party. We wish to now bring
these databases in-house.
As I understand it this should not be a complex procedure as the databases
currently sit on a SQL Server 2000 platform and we want to keep this
platform and set up and just move the databases to our server ie no
migration between Database Vendors or versions of SQL Server. The databases
aren't more than 1GB and al lot are much smaller

My question is this. It is almost as simple as the following :-

1 ) Installing SQL Server 2000 on our Windows 2000 server, adding the
necessary patches and configuration etc to bring it to the same level as the
current oursourced set up
2 ) Detaching the databases from the outsourced SQL Server
3 ) Attaching the databases to our SQL Server setup
4) Installing software and creating the links to the databases

Obviously we will need a DBA to administer this once the decision is made.
If we can't detach them do we need to re-engineer the databases and create
them on the new server somehow ?

Regards
Bil



Re: Migrating SQL Server in-house from outsourced company

Postby Andrew J. Kelly » Sat, 07 Aug 2004 11:43:53 GMT

Please don't post independently in separate newsgroups.  You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in .server.


-- 
Andrew J. Kelly  SQL MVP






databases
the



Similar Threads:

1.Migrating SQL Server 2000 in-house from outsourced contract

Hi

I am looking for some advice. My company currently outsources the hosting
and administration of our databases to a third party. We wish to now bring
these databases in-house.
As I understand it this should not be a complex procedure as the databases
currently sit on a SQL Server 2000 platform and we want to keep this
platform and set up and just move the databases to our server ie no
migration between Database Vendors or versions of SQL Server. The databases
aren't more than 1GB and al lot are much smaller

My question is this. It is almost as simple as the following :-

1 ) Installing SQL Server 2000 on our Windows 2000 server, adding the
necessary patches and configuration etc to bring it to the same level as the
current oursourced set up
2 ) Detaching the databases from the outsourced SQL Server
3 ) Attaching the databases to our SQL Server setup
4) Installing software and creating the links to the databases

Obviously we will need a DBA to administer this once the decision is made.
If we can't detach them do we need to re-engineer the databases and create
them on the new server somehow ?

Regards
Bil


2.Outsourced SQL Server Support

Does anyone know of a good company that perform remote 
sql server support?  The boss asked me to do some 
homework and I'd like to hear a few opinions.  If it 
matters, my compnay is in the midwest.

3.Installing Sql Server 2005 on company server

Hello -

I need to install Sql Server 2005 on a company server.  Is there anything I 
should know/read/study before doing this?  My experience has been installing 
in Windows 2000, Windows NT Server and Windows Server 2003 on my home PC, 
which was all pretty straight-forward.  

Any help will be greatly appreciated!!!
-- 
Sandy

4.Outsourced DBA?

5.ASP.Net with IIS and SQL Server in different hosting companies

You can do this if need be. I'm doing it for one of my clients because of 
the exact same cost reason for them. As to how much of a performance hit 
you'll take, it will depend upon where the database server resides in 
relation to the web server. There is always a penalty in performance due to 
latency. This could cause your app to appear slower since you could be 
running even half a second slower for database activities. To improve this 
performance try limiting the number of data accesses on a page. If your 
would normally return a number of datareaders, try getting one datareader 
with multiple resultsets that you can iterate through. This can improve 
performance because you're only using the one connection instead of 
numerous. You can run a trace (using tracert at the command prompt) to find 
the path to the various hosts to get an idea of where the datacenters are 
actually located and this could help you figure out a rough idea of the 
latency.


-- 
Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"Michel Couche" <Contact //@// michelcouhe.net> wrote in message 
news:eVa0hJs% XXXX@XXXXX.COM ...
> Hello,
>
> I am working on a project for a potential customer.
>
> The project will basically involve an ASP.Net  2.0 application and a 
> database (ideally MS SQL). The customer has already a hosting plan but it 
> does not currently include a MS SQL database. This option is offered as a 
> rather expensive add-on (600 US $ /year).
>
> If we need cost saving, I could offer to set-up a MS SQL 2005 DB on my own 
> hosting plan in a different company (I may have 10 DB's) and use it as the 
> database for my customer's web site.
>
> This would be a cheaper alternative but . do you think that there would be 
> a efficiency penalty ? I believe that as the IIS server and the MS SQL 
> server resides on separate machine with their own IP's  it should be 
> transparent for my application and there should be no penalty in terms of 
> user's perceived efficacy
>
> Thanks in advance for your feedback and advice,
>
>
>
> Michel
>
>
>
> NB: Last indication my hosting company is physically in the US and the 
> customer's hosting  is in the UK
>
>
> 


6. Webapplication with SQL Server for more companies

7. Purchasing Microsoft SQL Server for small company

8. SQL Server Company Layer



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 67 guest