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 |
|
Drewmon
Starting Member
6 Posts |
 Posted - 2005-12-01 : 12:08:30
|
| We are coming out of the dark ages with our app using SQL 7 and, following the excellent advice of the folks here on SQLTeam, installing SQL 2005 Express on our new webserver.Not being terribly fluent in all things SQL, I was wondering if anybody could provide input on the best practices for getting SQL 2005 Express going on the new server.So far I've:- Installed SQL 2005 Express- Downloaded and "installed" the SSEUtil for CMD line instructions- Downloaded and installed the graphical management interface (very nice, makes me feel more comfortable - like SQL 7 console!)- Copied backup files (made using SQL backup maintenance) to the new serverShould I simply create an empty db of the same name on the 2005 server and then restore the 7 data? Or ????I searched briefly for previous posts of this nature and didn't find too much info so I hope I'm not duplicating effort here...Thanks in advance for any advice!Mmmmmkay. Yeah, did you get the memo about the TPS reports? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-12-01 : 12:40:25
|
| Don't know if you can restore 7 to 2k5How many objects are you talking about?There are some new beneficial features in 2k5.I think I'd script the database and create a stage db in 2k5, leaving the contraints offbcp the data out of 7 and in to 2k5tweak the DDL to take advantage of any new features, correct any data corruption issues, Normal form issues, ect and create the databaseThen create a migration plan from stage to the final 2k5 databaseBut that's just meBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-01 : 12:49:49
|
| "Then create a migration plan from stage to the final 2k5 database"Perhaps VIEWS onto the new 2k5 tables that mimic the old SQL7 names, and then just create a Linked Server between Old and New and:INSERT INTO MyTargetServer.MyTargetDatabase.dbo.MyTableWhichIsNowAViewSELECT *FROM MySourceServer.MySourceDatabase.dbo.MyOriginalTableNameKristen |
|
|
|
Drewmon
Starting Member
6 Posts |
Posted - 2005-12-01 : 17:05:34
|
| So (my interpretation) it sounds like we'll need to pump the data "by hand" from the SQL7 db and see what breaks along the way.What about stored procedures?Mmmmmkay. Yeah, did you get the memo about the TPS reports? |
|
|
|
|
|
|
Moving from SQL 7 to SQL2005 Express- Any tips?