December 29, 2008 at 12:27 pm
I bought a new computer and found out it was 64 bit Vista. So long to my FoxPro app that kept track of books read and books I want to read. Time to port it over to SQL Server and C# for a front-end probably. But first I need to get my data moved. I don't know anything about DTS except that I can't get it loaded. I loaded on my new computer, the SQL Server Advanced Express that comes with Management Studio. I've tried everything I can but cannot get DTS loaded on my machine. So, with that being said, does anyone know of a way for me to get my free tables from FoxPro into SQL Server Express? Thanks for any assistance!!!
December 29, 2008 at 1:09 pm
It's called SSIS in SQL Server 2005 and it does not come with Express Edition, even with advanced services. http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx.
You could use a linked server and copy the data over. Or you could write a C# app to copy the data.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply