Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL server migration

 
Arjun Shastry
Ranch Hand
Posts: 1898
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
We have machine where SQL 2005 server is installed.Atleast 3 web applications are running on it with data size 22GB in all. We need to migrate all data/tables/groups/users from this server to another server.On target server, SQL server 2005 will be installed.After that this migration activity needs to be carried out.what are options available to migrate to target server?
Microsoft migration tool? Any already existing stored procedure etc?which is preferred solution in such case? java program?
(There are no explicit stored procedures/triggers etc) database structure is quite simple.

Thanks for help

 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can just backup and restore the databases. That's the simplest way.

If you have logic you need to perform during the migration, DTS is the tool Microsoft gives you to do this.
 
Arjun Shastry
Ranch Hand
Posts: 1898
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks.Backup and restore seems to be a easier option.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic