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 |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2002-06-25 : 07:12:46
|
| Hi, We have a database where one table has around 1,50,000 Records and many other tables having 100 to 1000s of records each.We also have indexing,many stored procedures written for this database.I want to export this database to another machine.I heard that if I use transfer objects across server option in the DTS Wizard, all the objects of source database will be transfarred to the destination DB.Is it so?...Actually I tried this option but i got an error stating that Failed to transfer objects....I tried this option across the internet.Is there any other option to do this?....KarunakaranDon't wait for things to happen,Make them to happen...Edited by - karuna on 06/25/2002 07:13:44 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-25 : 07:58:30
|
| Why not look at the front page of this site. It has a link to a relative article for this.........[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546&SD=MSKB[/url]PeaceRick |
 |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2002-06-25 : 08:04:46
|
| There are two issues with this. Check to see if the database you exporting to has any foreign key constraints. This may prevent some tables from loading.If this is the case, you might want to load all your base reference tables (tier 1 tables) first and then your tier 2 tables (those having foreign key constraints)Have you also checked to see if the receiving data has the same structure table to table? This could throw up errors in mismatching/data conversion.Danwww.danielsmall.com IT Factors<<monet makes money>> |
|
|
|
|
|
|
Export of Database