April 12, 2007 at 7:32 pm
Hi
I am doing migration of sqlsrv 2000 to sqlsrv 2005.
i successfully migrate database through back up and restore methods. and i tranfer the login successfully on sqlsrv 2005
but my problem is how could i migrate job , dtspackages and linked server pl guide me.....
thanks
jitu
April 13, 2007 at 10:14 am
Script jobs in Enterprise Manager and run the script in SQL 2005.
Save DTS packages as files and open them in SQL 2005 Management Studio - Management - Legacy - Data Transformation Services. You have to download and install the SQL 2000 DTS runtime (available from MS download page)first.
Script linked server with this script: http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=620 and run the script in SQL 2005.
Greg
Greg
April 13, 2007 at 11:44 am
Thanks for your guidence
jitu
April 18, 2007 at 2:03 pm
This is a good link...but the remote login password works only on SQL 7.0 ... any link to a script for decrypting or scripting remote login passwords from 2000 linked servers....
thanks in advance
Sunil
April 18, 2007 at 3:18 pm
It worked for me when I scripted linked servers on a SQL 2000 instance and created them on a SQL 2005 instance. Keep in mind that you can't find a password for a domain login, only for SQL Server logins.
Greg
Greg
April 18, 2007 at 4:56 pm
Thanks Greg, I was wondering if I can migrate linked server logins to Oracle databases ? did u migrate links to oracle DBs ?
April 18, 2007 at 5:01 pm
I have a couple of linked server pointing to Oracle Databases, I tried migrating those using the script. But, it did not work, any ideas how can we script these passwords out ?
Thanks
Sunil
April 18, 2007 at 5:29 pm
Sorry, I don't have any Oracle databases. Hopefully, someone who does will see this thread.
Greg
Greg
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply