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 |
|
novicecoder
Starting Member
2 Posts |
 Posted - 2009-08-01 : 01:40:58
|
| Hello,I have been assigned a task of migrating Foxpro databases and programs manipulating these databases to SQL server 2005. I have successfully migrated FoxPro databases using SSIS. Now I want to write SQL Code to work on the newly ported databases just as my previous foxpro programs did. I would like to know which is the best way for doing this ie Should I use standalone SQL Server Scripts or use stored procedures or write some stored procedures and call them thru SQL scripts. BTW, I dont have a front end for this application and there is no user interaction required. The user just wants to see the data in SQL tables. I am new to SQL Server and I am facing this design issue.Thanks in advance for the help.Best |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-01 : 08:31:51
|
Maybe you should have a look at MS SSRS (reporting services) to create an interface for "just loking at the data"?If that is a bit oversized for this I would go to create views to show the wanted data.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
novicecoder
Starting Member
2 Posts |
Posted - 2009-08-01 : 11:58:10
|
quote:
Originally posted by webfred
Maybe you should have a look at MS SSRS (reporting services) to create an interface for "just loking at the data"?If that is a bit oversized for this I would go to create views to show the wanted data.
No, you're never too old to Yak'n'Roll if you're too young to die.
Hello,Thanks for the reply. Yes I can use SSRS to report the data but I am really confused about how to process the data that I have imported. Earlier my foxpro programs where working on the data but now should I replace my Foxpro programs with SQL Scripts or SQL scripts calling stored procedure or just stored procedure. What is the right and the best way to do it?Awaiting a replyCheers |
|
|
|
|
|
|
Migrating Foxpro database programs to SQL 2005