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 |
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
 Posted - 2010-06-09 : 09:15:04
|
| I have a rather bunch of silly questionsI have a table with Primary keys defines and indexing defined in test environment.I have asked our DBA to copy the table to production from test.Will the copying of a table copy the keys and constraints also |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2010-06-09 : 09:20:53
|
| Take a script from test environment and run it in production Environment.Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-06-09 : 09:30:09
|
| There are 1 million records in the table.Can we have a script generated from the Management studio to create a table and insert the million recordsPlease advise |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-06-09 : 09:39:41
|
| Make use of Import/Export wizard from Management studioMadhivananFailing to plan is Planning to fail |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-06-09 : 09:45:31
|
That is interesting!To bring a table structure from TEST to Production is ok.To bring a million of rows from TEST to Produktion is weird.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
jim_jim
Constraint Violating Yak Guru
306 Posts |
Posted - 2010-06-09 : 10:00:09
|
| Can I ask why is it weird to copy million rows from a test environment table where it has been tested if the copying of tables does not work,Will use ssis to create a package to load data in production |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-06-09 : 10:14:15
|
Don't wanted to bother you  But in my experience data from test environment is always bad data because it is only for testing and it is not the whole data that is needed in production.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Copying tables