Paul
I haven't done this but you may be able to use xCase (www.xcase.com) to
rev engineer your existing database and then set it up on SQL-Server
2005. As for the 'best components' for SQL It would depend on how you
are using your existing db? Tables, queries, stored procs from your
statement "We know we will have to re-visit all the SQL for syntax and
probably for performance" in theory not but the devil is in the details
Are you using RI? is so how? The biggest issue is in the functions
/stored procs/trigger code ie the specific scripting code for the db
HTH
Neven
Paul McKenzie wrote:
We are considering migrating several Win32 (D7) 3-Tier apps from
IBX/Interbase to SQL-Server 2005.
The Apps all access the same large Database - The apps range from small
to very large.
What are the best components to use for SQL Server ?
What are the difficulties/gotchas in migrating ?
Any good links and/or best practices for migration ?
We know we will have to re-visit all the SQL for syntax and probably for
performance.
Are there any issues, we would probably not see until the end, that we
need to look out for ?
Any Help much appreciated...
--
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062
New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland
Ph 620 1356
Fx 620 1336
begin:vcard
fn:Neven MacEwan
n:MacEwan;Neven
email;internet:[EMAIL PROTECTED]
tel;work:649 620 1356
tel;fax:649 620 1336
tel;cell:0274 749 062
version:2.1
end:vcard
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
