We Talk Coding
Is there an easier way to register databases on a new instance of SQL 2005?
Say you already have several DB's registered and you have a new computer... Is there a way to transfer the specifications about those registered servers to your new computer and import them to auto register? anyone know of an easier way then manually going through the steps? anyone? Thanks.
Public Comments
- There is an easy way but it has to do with writing a script so it is not really the "easy" way. If you had to do it on 100 computers this might be the better choice of writing a script. Windows allows the provoking of VB based scripts called VBS which are standard in the operating system, also some bascic javascripts are enabled. Generally I would say you are better off just doing it manually.
- to transfer a data base in sql , first detach the data base 2nd go to the date base and copy the ldf and mdf file paste in sql , name the data base to the path and attach easy as can be
