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 |
|
cthompson
Starting Member
11 Posts |
 Posted - 2004-08-31 : 07:14:04
|
| I have to upgrade a 'SQL 7' server to 'SQL 2000' on the same server. Looking at information on SQL forum i have found information on creating scripts for re-creating Scheduled jobs/user logins etc. But i have found nothing on what to do with DTS packages and stored procedures.Does the upgrade to SQL 2000 re-create the DTS packages/Stored procedures or do i need to set-up a script to re-create the DTS packages/Stored procedures or some other method.Can someone give me some advise on what is the best method to re-create DTS packages/stored procedures.Thanks in advance.RegardsChris |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cthompson
Starting Member
11 Posts |
Posted - 2004-09-01 : 04:30:58
|
TaraThanks for this information, but I have already printed this information and this information does not explain what to do with DTS packages.But thanks anyway for the information.RegardsChrisquote:
Originally posted by tduggan
http://www.sqlteam.com/item.asp?ItemID=9066http://www.sqlteam.com/item.asp?ItemID=9465Tara
|
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-09-02 : 01:15:08
|
| Hey, Tara, thanks for the plug!Chris, I hope the articles were of use to you outside of the DTS issue. In regard to DTS, if you are using the technique in my articles (detach/attach) then no the DTS packages are not preserved. You will need to find a way to transfer them. I don't know of any way to script a DTS package, but you might be able to move them by using an external data store to move them out and perhaps back in.If you are running an upgrade wizard or install option, then I would expect them to be taken care of, however you will, of course, want to review and test each of them to make sure nothing went haywire.-----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-09-02 : 11:15:54
|
| Save them as structured sotrage files and then open them once you have the new server installed. |
|
|
|
cthompson
Starting Member
11 Posts |
Posted - 2004-09-13 : 09:22:34
|
| Thanks for the information.RegardsChris |
|
|
|
|
|
|
Upgrading Sql7 to Sql2000