Thanks for the info Andy, some definite oversites on my part. I try to write some generic routines and put the articles out so they are generic enough that...

By list I guess I meant for each database. It would be easy enought to create something that would search for the backups of a given database. In my...

Interesting thoughts. I know I use the backup and restore method to bring our production database down and then restore it to a local server to a database with...

Wow these are both awesome solutions to a problem that when I read thought was going to be really difficult.

Bruce Szabo, MCSE+I, MCDBA, MCSD

You could create a temporary table in SQL and then move the data from foxpro to this temporary table. I would then do a two step transformation and move...

Oh that make sense. You could have used MSDE on the local desktops if you wanted to have them take SQL with them. At least you were able...

I am not sure if I can answer this directly but this is what I get when I try and transform from a flat file to a SQL server table....

I thought you would have had another SQL server from which to run a package that just uses Server2 as the source and destination.

Can you run a saved...

SP4 couldn't hurt, well it could but it is not suppossed to. 🙂 Why not just link to the Access database instead of migrating, the access data projects give...

I migrated from 6.5 to 7. It seemed as though getting the users setup was a much needed first step. The transition from 7 to 2000 may be...

It is hard to say what is going on without all the information. I agree with Michael. The first guess would be the servers should probably be in...

Is the only way you can get to the server FTP? If you can get there with the filesystem you can use the filesystem object in an activeX task...

Hi Brendon,

I think you should be able to do this with the filesystem object in vbscript. I have had a lot of success utilizing the filesystem object in my...

I actually did have luck updating my models in Visio. It was before I had any data in it though which I could imagine would make a world of...

To Andy's point I agree that SQL may have tools that can help you out. In my case though and I did not spell it out in the article...