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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2005-01-30 : 14:43:22
|
Hi people,I need to move a 300MB database from my laptop to a production server that I have access to using EM/QA but not the filesystem/ftp or anything like that. I have tried the "import data"-wizard in EM but for some unknown reason it fails and I'm left basically clueless...any pointars people? Unfortunately I'm in somewhat of a hurry  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-30 : 17:17:04
|
| Are you a backup administrator on the server? Can the server see your laptop? Save the "import data" as a DTS package, run it again, then look at the history. You should get more information that way.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2005-01-30 : 17:50:56
|
The server can't see me I belive...it's quite a few hundred miles away and I'm not on a network or anything, just standard internet stuff (remote hosting). But I found out that the database was limited to 50MB actually so I guess that explains it  I ended up scripting the database and just load that without the data...it will have to do until tomorrow when I can get the DBA's to increase the size of that baby.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-01-30 : 22:58:41
|
| Are you using a web hosting company for this? It would be pretty rare for them to not allow you to ftp stuff, then restore to the DB. I would check with them on that.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2005-01-31 : 04:10:15
|
Yes, I am using a web hosting company but the problem is that the sql server is on a separate box but shared as well so there are quite a few people having their own databases on this server. I am of course allowed ftp on the webserver but since it's on a separate box it doesn't do me much good. Thank gawd this was a freelance-project and not my daytime job...doing stuff on a shared database I belive could cause some uncalled for headaches  --Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
Moving 300MB database