| Author |
 Topic  |
|
|
Astralis
Senior Member
USA
1218 Posts |
 Posted - 13 March 2005 : 17:13:20
|
How do I backup/copy a hosted MSSQL DB onto my computer? I do not have a SQL DB on my computer. I also want to be able to manipulate the data and reupload it if necessary.
What recommendations? Is it possible to back it up into an Access DB? I can't imagine no one is backing up their hosted databases or paying their host $20 everytime for a backup. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 13 March 2005 : 17:26:29
|
You could create a local Access based forum and then, periodically, use SQL Server DTS to export your SQL Server database data to the local Access DB. It's possible and doable. If your database is big, it could take some time, but it's definitely doable.
The transfer should be done paying attention to some details, namely configuration the transfer of each table so that existing data is deleted and identity insert is active.
Of course you could also have another simple alternative: create a DSN for the SQL DB and then import each of the tables to the Access DB. Like this you could even keep different Access DBs corresponding to different dates. The downside to this would be that the import of the table structure wouldn't result in a correct table structure for each table, but the data thus obtained would be usable to reexport to the SQL Server DB, if and when needed, using DTS, without problems. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Astralis
Senior Member
USA
1218 Posts |
Posted - 13 March 2005 : 17:33:37
|
| Is there another method of getting the data as an exact copy through EM. I guess this would mean the data can't be manipulated once downloaded, right? But, at least I would get a copy. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 13 March 2005 : 17:53:06
|
| Data can always be manipulated in an Access DB. I don't see other way of obtaining a copy of the data, since you explicitly said you wouldn't have an SQL Server local DB. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Astralis
Senior Member
USA
1218 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 15 March 2005 : 19:19:14
|
Before you go the Access route for backup you should review your database structure. There are incompatible datatypes between MSSQL Server and Access. Also SP's, diagrams, and other SQL Server objects won't be able to be saved in an Access backup.
I'd install the Developer edition of MSSQL Server, or MSDE, and then use DTS to completely copy my hosted DB.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
| |
Topic |
|
Topic Locked
