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-16 : 08:21:42
|
| Hi,I am new for SQL server and we have test database with normal setting and planning to move into production.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.What's the ideal configuration parameters and other thing i need to keep in mind while migrating/creating into Production using back up/restore method?Eventually DB will grow in production but i am not aware at this point that what should be the growth level.But I am expecting to 50k to 100k rows in each 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 what should be the ideal production configuration setting like file size etc.I know that its hard to tell without knowing DB growth but if you just give me roughly idea about normal mid size DB configuration will be great.I know in oracle init.ora gives you some kind of ideas.Thanks and appreciate! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 10:14:05
|
| Why are you repeating? Answer has already been given here.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=117654 |
 |
|
|
pora
Starting Member
15 Posts |
Posted - 2009-01-16 : 11:28:38
|
| Sorry for duplication as i lost that thread somehow but thanks lot for reminding me.I have already replied back to original thread.Thanks. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 11:56:29
|
| Your question: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,Pora2)Yes.3)If you are using XML data type ,otherwise you don't need it. |
|
|
|
pora
Starting Member
15 Posts |
Posted - 2009-01-16 : 23:09:57
|
| Thanks Sudeep, appreciate it. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 23:48:52
|
| Welcome. |
|
|
|
|
|
|
Migrate DB and ideal configuration