sql server new users: database created in different Versions -- sql server new users

Re: database created in different Versions

Sue Hoegemeier
4/12/2007 10:27:12 AM

You can go up in versions but not down in versions. So you can go from
SQL 2000 to SQL 2005 but you can go from SQL 2005 to SQL 2000.

-Sue

On Thu, 12 Apr 2007 22:20:04 +0800, "Ali" <mohd_ali@rocketmail.com>
[quoted text, click to view]

Re: database created in different Versions

Hari Prasad
4/12/2007 11:24:47 PM

Hello,

From SQL 2000 to SQL 2005 you can attach a database. But in SQL express
there is a limitation of 4 MG data fie (MDF). So if you have a database
with more 4 GB MDF size in
SQL 2000 then you will not be attach to SQL express.

But from SQL 2005 to SQL 2000 is not supported. You will have to use DTS or
SSIS to move object and data.

Thanks
Hari

[quoted text, click to view]

Re: database created in different Versions

Aaron Kempf
5/2/2007 7:13:03 PM

well I've sure had problems doing this.. but it's a fairly large database

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.