Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dblount
Starting Member
1 Post |
 Posted - 2009-08-04 : 16:16:46
|
| I'm not sure if this is the right place to post this or not, but here goes.I have a SQL 2005 Express install that has reached the 4GB database limit. This database houses SharePoint 2007 and I need to move the data to a SQL 2000 server. Is this possible? I know 2005 & 2000 SQL databases are written differently, but I'm checking all available options.SharePoint is done on a standalone server & explains why 2005 Express was installed. The 4GB database limit was overlooked in planning & now we need more space. 2005 standard is an option, but as a last resort. The program the company uses can't run on 2005, so we have been asked to try to use a SQL 2000 install. This would all be housed on a standalone server. I know I can have the 2005 Express & 2000 SQL running at the same time due to different install directories.The big question is can I move the 2005 Express data to the 2000 SQL database? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-04 : 16:24:37
|
Not directly. You will have to script all data to a file (using BCP) and then import all data in SQL Server 2000.Or INSERT INTO SQL2000 SELECT FROM SQL2005 approach.Beware of IDENTITIES, you may want to useSET IDENTITY_INSERT {TableName} ONINSERT INTO SQL2000 SELECT FROM SQL2005SET IDENTITY_INSERT {TableName} OFF
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-04 : 16:30:18
|
Even if you install a database on a SQL Server 2005 server, you can set the database in SQL Server 2000 compatible mode...
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
2005 Express Woes