var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Copy 800MB into SQL through ODBC dsn???
hello, i am a simple web developer with lots of database administration experience but zero sql scripting experience.
i need to do a full copy (not delta) of an 800MB UnisysMapper database through an ODBC driver into my Windows SQL 2000 server. it needs to be a script that can be automated to run once a week.
i dont know where to start. all i have are guesses. is there a quick way of doing this? can someone suggest a quick set of steps for me to get rolling?
should i record a VB script with DTS wizard and edit it? if so, how do i schedule it?
should i use a stored procedure (Transact-SQL) instead?
help please! to give me a quicker answer reply to me at email@example.com
I used DTC job and scheduled that, to suck a lot of data 1GB from a mainframe DB2 into 2000 and that worked a treat.
The throughput was fairly quick at 5 k-rows/sec.