Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


migration of 2000 --> 2005 sql server:


migration of 2000 --> 2005 sql server:

Author
Message
John Esraelo-498130
John Esraelo-498130
Mr or Mrs. 500
Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)

Group: General Forum Members
Points: 547 Visits: 1029
Hello all,
I was wondering if someone can tell me:
> if the import / export wizard is 100% bulletproof in migration of 2000 to 2005 ss?
> what is the purpose of dtproperties table in 2000

thx

John Esraelo

Cheers,
John Esraelo
SQL ORACLE
SQL ORACLE
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1487 Visits: 1314
Here are my inputs.
1. I cannot say 100%. But it should not have any problem in general.
2. dtProperties in SQL 2000 is a system used to store info for diagram.

Any others would like to have more input?
John Esraelo-498130
John Esraelo-498130
Mr or Mrs. 500
Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)

Group: General Forum Members
Points: 547 Visits: 1029
the reason for asking the question number 2 was that I was playing around with the iBuySpy, I am not sure if you are familiar with that or not, and noticed that there were some code in C# and stored procedures in sql server 2000 that are refering to the dtproperties and sysusers. Therefore, I was concerned with the fact that I may have to compensate if the wizard does not transfer or migrate that table over properly. Does this make sense?
thx

JohnE

Cheers,
John Esraelo
Ramon Jimenez
Ramon Jimenez
Mr or Mrs. 500
Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)Mr or Mrs. 500 (576 reputation)

Group: General Forum Members
Points: 576 Visits: 121
You can always leave database with SQL Server 2000 compatibility level

Regards Ramon
SanjayAttray
SanjayAttray
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3953 Visits: 1619
My best and safest bet would be to backup 2000 database and restore it on 2005 and change the compatibility mode, transfer logins using script given in this link, map users and logins, remove all the user schema's from database. If you have dts packages on 2000 server then save them into structured file and then move to 2005. (check legacy in M M Studio)


http://support.microsoft.com/kb/246133 -- Check method 2 for transferring logins from 2000 - 2005.

SQL DBA.
SanjayAttray
SanjayAttray
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3953 Visits: 1619
Ramon Jimenez (2/13/2008)
You can always leave database with SQL Server 2000 compatibility level



I tried this and had lot of problems in full text search indexes when SQL server 2000 database is put into compatibility mode 80 in sql server 2005. Not a good choice.

SQL DBA.
John Esraelo-498130
John Esraelo-498130
Mr or Mrs. 500
Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)Mr or Mrs. 500 (547 reputation)

Group: General Forum Members
Points: 547 Visits: 1029
I do not have any search index going on... so I should be good to go if I go to the link and check out the script...
thank you guys.
I will give that a shot.

John Esraelo

Cheers,
John Esraelo
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search