Hi Guyz,

 

I want to transfer my current SQL Server 2005 instance (includes two DBs, SSRS deployment & bunch of scheduled jobs in SSIS) from my current server to a new one. I can transfer the DBs easily by detachching or copy DB. But the real problem is the server configuration. Is there any way that i cud transfer my current sql server configuration (the whole instance including the SSIS & SSRS + security configurations) to a new place / server ?

A quick help is highly appreciated. Thanks in advanced.
 

---

Regards,

:: SHAMIRA ::

Hi,

When performing a migration of this sort, different aspects of the migration should be done separately.

You may have to migrate the msdb database which stores all the scheduled jobs or you could use the Transfer Jobs Task in Integration Services to transfer the jobs between the servers.

To transfer SQL Server objects such as SQL Server logins and object level permissions you could use the Transfer SQL Server Objects tasks.

To migrate your Reporting Services infrastructure you could follow this step-by-step manual: http://support.microsoft.com/kb/842425.

Let us know on how things go.

Regards

---

Gogula G. Aryalingam (MVP - SQL Server)

If you like to have the dataabses in the same instance ,same environment in the new server and you have authority to create same directories there following is the easiest method.

http://vyaskn.tripod.com/moving_sql_server.htm

 

---

Skype: sanjeeva.s
Mobile: +94-773154465
Blog :http://sanjeevas.spaces.live.com/