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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2005-08-23 : 06:23:21
|
| Hi friendsI have a database where i need to replace with a new version of the same one.Can anyone suggest the best possible and reliable way of doing thatregardsVicVicky |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-23 : 09:25:17
|
| Are you talking upgrading the SQL server from v7->v2000....or upgrading a user-database supplied from an (external/internal) supplier? Re the latter do you wish to retain the data already stored (pre-upgrade)? |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2005-08-23 : 15:06:19
|
| well the supplier is giving us a new set of databaseideally we dont want to use the old databaseIts completly new one...and is given in a cd which has the name as the [oldone].mdbregardsVicVicky |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-23 : 15:59:31
|
| .mdb? Is it Access? Just replace the old one with the new one, assuming there is nothing in the old one that you want to keep.If it's actually SQL Server, then do a RESTORE DATABASE, again, assuming there is nothing in the old one that you want to keep.BUT, if the old one actually has data that you have been putting into it (not just reading from it) and using for real, then you need to contact your supplier to get an update program or script that will install the new components and still preserve the old info that you need to keep.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
replacing the new version of the database