February 19, 2003 at 4:57 am
Hi all !
I need to migrate from SQL7 to SQL2K My SQL dbs i did the following
1/Copy DB files at OS level from Old server to new server
2/Reattach the users Databases ONLY to the New SQL2000 server pointing to DATABASES Files previously copied
3/Launch Reindex process on Databases
4/Update statistics on users databases
5/Enable Fulltext on users databases
6/rebluid Fulltext catalog
7/Copy Jobs from SQL 7 server to SQL 2000 server
8/Copy Logins and passwords from SQL 7 server to SQL 2000 server
Does anyone approve this method ?? or other ideas ??
I wanna now transfer DTS packages from SQL7 to SQL 2K but how ????
thanks for your help !
Steph
Steph
February 19, 2003 at 7:01 am
"I wanna now transfer DTS packages from SQL7 to SQL 2K but how ????"
Go to your DTS package and choose "save as...", you can choose the location where to save your DTS package here.
HTH
Franco
Franco
Franco
February 19, 2003 at 7:08 am
Thanks Franco for your answer
Do you mean.. it's necessary to do it one by one ... but i have one thousand DTS !!!!
Steph
Steph
February 19, 2003 at 7:15 am
From Neil Pike:
You have three choices:
1.Use the DTS transfer wizard. Set msdb as the source and destination databases and "select * from sysdtspackages" on the source.
2.Save each DTS package as a file. Copy the .dts files created to the target machine. From EM, right click Data Transformation Packages and choose all tasks Open Package for each package.
3.Open them in the package designer - choose save as, and save them to the other server.
Option 1 is the quickest for lots of packages.
ALso refer to:
http://www.sqldts.com/default.aspx?6,105,204,0,1
HTH
Franco
Edited by - franco on 02/19/2003 07:17:16 AM
Edited by - franco on 02/19/2003 07:18:53 AM
Franco
February 19, 2003 at 8:34 am
Thanks Again .. i'm gonna apply the method
stored in the link SQLDTS.com you have written in your answer.
Thanks
Steph.
Steph
Steph
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply