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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-19 : 07:19:41
|
| Aji writes "HiI am new to advanced DB features. I have referred to u're FAQ section, but did not get anything that helps.My problem is that I have a Delphi program that uses a Paradox DB. This DB has several tables. This program has several installations globally. Now to move the application over to the web, we have to find some way of moving the data(like import in SQL Server) from the Paradox tables to a SQL Server DB to be used in ASP. The amount of data to be transferred is also considerable.To top it all, after migrating to SQL Server, we need to convert all the ID fields(primary key - an integer field) in the different tables to GUID's !! and also taking care of referential integrity in the related tables.So, is there any way of writing a stored proc or trigger that could automate this process. This has to be some kind of automated process because the procedure to move data from Paradox to SQL and then converting id's in SQL has to be done at least 500 times !!! i.e. whenever someone sends over their Paradox DB from some part of the world.Hope u can helpAji" |
|
|
Tim
Starting Member
392 Posts |
Posted - 2003-05-20 : 01:14:33
|
| is it a once off conversion of data, or do you intend to keep updating the remote databases and merging to the SQL server? |
 |
|
|
|
|
|
Automated proc to migrate Paradox DB to SQL DB and modify values