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 |
|
Aerodyne
Starting Member
3 Posts |
 Posted - 2004-07-13 : 00:19:22
|
| Hi there,I'm new to using DTS, so a little help would be appriciated.I need to upload a db created in Enterprise Manager (SQL 2000 sp3), I figured how to u/l the tables & SPROC but how can I u/l the primary key values & the table relations + index stuff.Also how do i clear everything that in the db at the mo?TIAP.S. A step-by-step guide if possible ...newbie ;-) |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-13 : 01:06:07
|
| In what format is the exported database?If you have the database in .MDF format or SQL backup format, you can upload it directly without having to muck about with DTS.If the original db is still live, simply do a detach (right click the database in E/M, select 'All tasks' --> 'Detach Database'). Then you can copy over the .MDF and re-attach using E/M.HTH,Tim |
 |
|
|
Aerodyne
Starting Member
3 Posts |
Posted - 2004-07-13 : 06:29:17
|
| Thanks...But I can't copy the *.MDF file 'cos I have a specific IP addr to send it to, using a user name and password. |
|
|
|
Aerodyne
Starting Member
3 Posts |
Posted - 2004-07-13 : 12:07:23
|
| Hmmm ... I've sorted it out.For some reason it would not tranfer over the correct format to the IP addr, & when I checked the db w/ the SQL Web console, it just had all the data repeat it self & acting really weired.But any way I think I sorted it out. |
|
|
|
|
|
|
DTS export