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 |
|
pora
Starting Member
15 Posts |
 Posted - 2009-01-12 : 12:38:37
|
| Hi,I am new for SQL server and we have test database with normal/default setting and planning to move into production.Currently we don't have much data (let's say 10-20 records, total 5 tables)but it will grow and i don't want to migrate with current default setting as I have previously created DEV database (Dev server) and taken back up and restored using SSMS into TESt server.So I have now DEV and TEST database.We have built a production server and i need to migrate DB into Production server.I have questions:1)Should I use the same technique to move DB from TEST to PRODUCTION?2)What's the ideal configuration parameters and other things i need to keep in mind while migrating/creating into Production?Eventually DB will grow in production but honestly i am not aware this point that what should be the growth level.But I am expecting to 50k to 100k rows in all five tables.We will be getting data through .Net application using web service and incoming file is in XML Format and will be loading into RDBMS sql server tables.Please let me know which procedure i should follow with ideal production configuration.Thanks and appreciate! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 12:44:50
|
| 1)Test and make sure it is efficient in terms of performance before migration2)You can use backup/restore or attach/detach approach. Rebuild index and stats after migration.3)Take advantages of XML indexing if it is largely used in prod.4)Take advantages of Table Partitioning if Enterprise edition.5)Put TempDB and log files in faster disk subsystems. |
 |
|
|
pora
Starting Member
15 Posts |
Posted - 2009-01-16 : 11:26:22
|
| Thanks Sodeep.1)What's the easiest method to test it and make sure it is efficient?2)I will be doing Backup/Restore approach, still i need to Rebuild Index?3)Original file is in XML format but we are loading in RDBMS tables, still i need to XML indexing, if yes then how it can be?Thanks once again for your response and detail steps.Regards,Pora |
|
|
|
|
|
|
Migrating SQL server 2005 Test DB to Production