If you are transferring the whole db, I would not use DTS, I would use T-SQL jobs to do backup and restore. If they are on seperate machines you could use a command shell script to copy the file over. There is the copy db wizard in DTS that you could look at as well
2004-03-08
You have a lot of choices when using DTS to import data. The simplest thing you can do to avoid having to reassign permissions on the destination tables is to just empty the tables before importing the data from Oracle rather than dropping and creating them. Use an Execute SQL Task with either DELETE FROM or […]
2004-03-05
Hi there, may I start a discussion on the rules for the monthly contest? I think it is no good thing to give 2 points for EACH post in the fora! Members might take this to post to each and every topic, no matter how wrong or useless their answers are. Quantity is not quality. […]
2004-03-03
1 reads
PARTYPARTY! I AM A 25POSTER!Seriously tho, I think they're doing this on purpose, these trickquestions. It DOES generate a lot of traffic.And, let's mot get too serious. As stated in a previous post: all this is free of charge to US, readers & respondants.At least, I never made a voluntary donation...
2004-03-02
2004-01-08
Hi,Subforms are set at the form level! In your subform control click properties and set the master and child link properties. This will cause your subform to appear filtered as if an inner join had been performed. You do not need to do this explicitly in SQL, if you are using the sub-form control. For […]
2004-01-06
quote: I haven't found a good MySQL book. At least from the DBA perspective, but it has a number of interesting abilities. I think Paul DuBois wrote the technical reference on MySQL4. Have you tried this? Maybe more interesting than MySQL in terms of a 'grown-up' RDBMS is MaxDB the former SAP DB, which is […]
2003-12-29
Rather than estimating, I would do it by taking regular transaction log backups whilst applying the transactions in test mode. Look at the size of the tlog backups (or run queries against the msdb backup tables) and also regularly save results of DBCC SQLPERF(LOGSPACE). That should give you an idea of requirements. BTW: I would […]
2003-12-15
1 reads
Also, you can increase the quantity of log files retained by right clicking on "SQL Server Logs" in Enterprise Manager, click on "Configure...", click the check box and modify the quantity. Steve
2003-12-11
1 reads
Thanks. I was already thinking of doing the "alternative". It would probably be better long run as I won't have to remember to revoke everything for new users/roles. Buddy
2003-12-09
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers