This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes SQL server migration Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL server migration" Watch "SQL server migration" New topic
Author

SQL server migration

Arjun Shastry
Ranch Hand

Joined: Mar 13, 2003
Posts: 1874
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



MH
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

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.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Arjun Shastry
Ranch Hand

Joined: Mar 13, 2003
Posts: 1874
Thanks.Backup and restore seems to be a easier option.

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL server migration