Viewing 15 posts - 61 through 75 (of 77 total)
1. run upgrade advisor against the dts package location - check if can be migrated
2. export as storage file from 2000
3. import into Legacy section in sql 2005
4. make sure...
April 8, 2008 at 6:14 am
Yes thats helps... we have another sneaky problem as the server is only reporting 3.2GB of RAM i have found this article http://support.microsoft.com/kb/929580/
bearing this is mingd if...
April 8, 2008 at 5:41 am
Hi reading through all this has me a little confused....:unsure:
I have Windows Server 2003 EE, 4GB Ram, SQL Server 2005 SP2.
SQL currently using around 1.6Gb, we need to allow it...
April 8, 2008 at 4:53 am
With regards to login scripting, if they are sql logins they may be 'orphaned users' when you restore the databases as SID's different. Most of our logins are NT...
March 14, 2008 at 4:14 am
Btw - backing up dbs and restoring to the new instance is fine. Downtime increased though. What about DTS packages, SQL Agent Jobs and Maintenance plans? these will all have...
March 14, 2008 at 4:02 am
Yes they will work fine i have tried and tested this and migrated system accross. One thing to note is ODBC client config setting. Providing it uses 'dynamically determine port'...
March 14, 2008 at 3:58 am
Ramesh,
as stated in my reply last night, you will need to download Microsoft SQL Server 2000 DTS Designer Components. You can do that from here http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
Scroll down the feature...
March 14, 2008 at 3:32 am
hi, the majority of dts's do migrate...but test and test again as sneaky bugs i am still finding and reporting to MS.
to migrate a whole dB..easiest is to backup 2000...
March 13, 2008 at 4:35 pm
thanks i will try that next time..as with most client requests it had to be done, well, when i asked the question..!!! as always!
... so with a bit of...
March 13, 2008 at 4:25 pm
This will work, but i have not tried it in a production environment.... so test then test test ! once you do this...SIDS may get out of sync...so use script...
February 20, 2008 at 6:50 am
An update from MS......
Hello SQL Server community! Just wanted to let you know that your ask did not go unheard with the SQL Server development team. We do look at...
February 19, 2008 at 3:43 am
Look everyone its working...please keep voting...a formal response from MS coming soon... vote vote vote!
Matthias Berndt wrote "YES" on 16/02/2008
Hello SQL Server community! Just wanted to let you know...
February 19, 2008 at 3:38 am
I know there is a way to something similar from VB and C#
Visual Basic
Dim instance As System.Data.Sql.SqlDatSourceEnumerator = _
System.Data.Sql.SqlDataSourceEnumerator.Instance
C#
System.Data.Sql.SqlDataSourceEnumerator instance =
System.Data.Sql.SqlDataSourceEnumerator.Instance
February 19, 2008 at 3:17 am
Look everyone its working...please keep voting...a formal response from MS coming soon... vote vote vote!
Matthias Berndt wrote "YES" on 16/02/2008
Hello SQL Server community! Just wanted to let you know...
February 18, 2008 at 3:31 am
Viewing 15 posts - 61 through 75 (of 77 total)