迁移sqlserver 数据库

迁移工作分为两部分：1）技术上的 2）沟通和流程上的

技术部分：

参照了这个帖子：http://fengyu.souidc.org/sqlserver_transfer.htm

安装完sqlserver 后，会有几个缺省库，其中master 库 存贮了login account 信息， 和用户自己创建的一些sp和xp， msdb存贮的job,
在迁移中我们关注的是login, job, user objects in master.

1)Check the database owners of all the databases.
select distinct sysprocesses.DBID,suser_sname(sysprocesses.sid) db_owner
 from sysprocesses,sysdatabases
where sysprocesses.dbid=sysdatabases.dbid

2)Make a list of logins and the permissions they have.  and run on new server
add_login_to_aserver.sql

3）Check the jobs, the job owner and the location of the output files of the job if any.
 you can just script. them (from EM by right clicking on the job and clicking generate script) and run it on the New server which would create the jobs (Recommended method)

4）
Check for any user stored procedures in Master Database, if any, script. them. 
you can just script. them (from EM, right click on the master db, All tasks>Generate sql script. > click 'script. all objects'

5) fix the orphan users.
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm