Skip to main content
added 28 characters in body
Source Link
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

I want to know the best and the most convenient way to migrate the whole data includes: - Security and permission - Users and memberships - All of the databases and ..

Best method to migrate data and all objects related to particular database is by using backup and restore method.Perhaps since you want to migrate whole database to new instance you can backup all user and system databases and restore it on new SQL Server instance

Backup database on current server and copy it to new server and restore it there.

You have to backup system database and restore it on new instance.How to backup and restore system databases. First do backup and restore of system databases.

Backing up and restoring system databases would provide you all logins, jobs and packages stored in MSDB to new instance. New server would also include complete securables and permissions

SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version andor if you have to stay on 2005 make sure all SQL Server instances are patched to SP4.

I want to know the best and the most convenient way to migrate the whole data includes: - Security and permission - Users and memberships - All of the databases and ..

Best method to migrate data and all objects related to particular database is by using backup and restore method.Perhaps since you want to migrate whole database to new instance you can backup all user and system databases and restore it on new SQL Server instance

Backup database on current server and copy it to new server and restore it there.

You have to backup system database and restore it on new instance.How to backup and restore system databases. First do backup and restore of system databases.

Backing up and restoring system databases would provide you all logins, jobs and packages stored in MSDB to new instance. New server would also include complete securables and permissions

SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version and make sure all SQL Server instances are patched to SP4

I want to know the best and the most convenient way to migrate the whole data includes: - Security and permission - Users and memberships - All of the databases and ..

Best method to migrate data and all objects related to particular database is by using backup and restore method.Perhaps since you want to migrate whole database to new instance you can backup all user and system databases and restore it on new SQL Server instance

Backup database on current server and copy it to new server and restore it there.

You have to backup system database and restore it on new instance.How to backup and restore system databases. First do backup and restore of system databases.

Backing up and restoring system databases would provide you all logins, jobs and packages stored in MSDB to new instance. New server would also include complete securables and permissions

SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version or if you have to stay on 2005 make sure all SQL Server instances are patched to SP4.

edited answer to match with question OP asked
Source Link
Shanky
  • 19.1k
  • 4
  • 36
  • 58

I want to know the best and the most convenient way to migrate the whole data includes: - Security and permission - Users and memberships - All of the databases and ..

Best method to migrate data and all objects related to particular database is by using backup and restore method.BackupPerhaps since you want to migrate whole database to new instance you can backup all user and system databases and restore it on new SQL Server instance

Backup database on current server and copy it to new server and restore it there.You would have to migrate logins and jobs pertaining to database manually.

If you want toYou have exactly same copy a you said you can also use attach and detach method to movebackup system database from one server to other.

You can take help of This link to migrate logins betweenand restore it on new instance.How to backup and restore system databases. First do backup and restore of SQL Serversystem databases.

If you have any jobs which were specific to database you are migrating youBacking up and restoring system databases would have to script outprovide you all logins, jobs and run the script onpackages stored in MSDB to new instance. New server to manually create jobswould also include complete securables and permissions

SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version and make sure all SQL Server instances are patched to SP4

Best method to migrate data and all objects related to particular database is by using backup and restore method.Backup database on current server and copy it to new server and restore it there.You would have to migrate logins and jobs pertaining to database manually.

If you want to have exactly same copy a you said you can also use attach and detach method to move database from one server to other.

You can take help of This link to migrate logins between instance of SQL Server.

If you have any jobs which were specific to database you are migrating you would have to script out jobs and run the script on new server to manually create jobs

SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version and make sure all SQL Server instances are patched to SP4

I want to know the best and the most convenient way to migrate the whole data includes: - Security and permission - Users and memberships - All of the databases and ..

Best method to migrate data and all objects related to particular database is by using backup and restore method.Perhaps since you want to migrate whole database to new instance you can backup all user and system databases and restore it on new SQL Server instance

Backup database on current server and copy it to new server and restore it there.

You have to backup system database and restore it on new instance.How to backup and restore system databases. First do backup and restore of system databases.

Backing up and restoring system databases would provide you all logins, jobs and packages stored in MSDB to new instance. New server would also include complete securables and permissions

SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version and make sure all SQL Server instances are patched to SP4

Source Link
Shanky
  • 19.1k
  • 4
  • 36
  • 58

Best method to migrate data and all objects related to particular database is by using backup and restore method.Backup database on current server and copy it to new server and restore it there.You would have to migrate logins and jobs pertaining to database manually.

If you want to have exactly same copy a you said you can also use attach and detach method to move database from one server to other.

You can take help of This link to migrate logins between instance of SQL Server.

If you have any jobs which were specific to database you are migrating you would have to script out jobs and run the script on new server to manually create jobs

SQL server 2005 is out of mainstream support its highly advisable to upgrade to latest SQL server version and make sure all SQL Server instances are patched to SP4