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 |
|
tekiusfanatikus
Starting Member
1 Post |
 Posted - 2008-01-17 : 20:30:24
|
| I'm currently on a shared hosting plan which has a SQL Server component to it.At the moment, I'm on 2000. I have a DTS package that runs locally and does a backup of the remote database and backs that up using sequential file numbering.I'd like to move to 2005, but I'm not sure quite how to replicate this process. Basically:- I don't have access to the server as it's shared hosting- I don't have the credentials for backups and stuff like that- They only send backups on demand- They don't perform regular backups on your data- They won't have the backups saved to my web directoryIf I:- use import/export, which is almost the only thing I know I can use, I can only copy tables and views. I'd like to copy everything (SPs, Functions, ect)The only thing I can come up with is software that would compare the structure and data and generate T-SQL to copy it over (ie. Apex SQL).Is this my only hope on SQL 2005? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 20:56:58
|
| Sql2k5 doesn't have magic on this, just migrate your dts package over. |
 |
|
|
|
|
|
Shared hosting - hassle to backup