Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-15 : 07:47:59
|
| Kapil writes "i m a student and learning and creating project in jsp. i m creating a project on online shopping system. i already completed my project. now a problem arise in front of me. i m having my database in sql server 2000 in my computer institute, where i m developing my site. now i have to give a presentation and demonstration of my project in my college. my data is in my institute's system. from which i have no link to my college's computer. do i have to create my database again in college's computer or there is another solution to move the database from my institute's computer to another computer on a portable media like floppy or cd. plz guide me my presentation is in two days. and i m newbie to sql server i only knows how to create database and retrieve the records from sql queries. thanx" |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-07-15 : 08:10:13
|
| You can make a BACKUP of the database (i.e. a Full Backup) on the college server, copy the backup file and then RESTORE it on the target system.The Login names will not work - hopefully you have set up Roles for your permissions, rather than granting them to individual logins. If so once you have Restored the database you should Drop any Users IN THE RESTORED DATABASE, create Logins [to the server] if necessary, then create Users in the database and Grant them the appropriate role.(The Backup, Restore and User/Roles/Permissions tasks can all be done using Enterprise Manager)You will presumably need to modifiy the connection string of your application, so it finds the new server.That should be it!Kristen |
 |
|
|
|
|
|
moving a database from one server to another