BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  How to start          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Marek Ratajczak Guest Posted: Fri Sep 05, 2003 12:52 pm    Post subject: How to start Hello, I have few years of experience with BDE, Paradox and TTables, but I'm quite new to sql servers. I know that I will have to rebuild all my application using new components and ideas. But I'm not sure which components shoud I choose. I've got D6. It seems to me, that I should use dbExpress components with DSP & CDS. Is this the best solution? I mean speed, stability etc. Is it (in practice) possible to simply change DriverName in TSqlConnection to work with different sql servers? Which sql server should I choose? Licence prices are very important to my customers, so I would like to choose server, which is not too expensive. Is IB6 Open Source a good idea? Thanks for help. Regards, Marek Ratajczak. Back to top Bill Todd Guest Posted: Fri Sep 05, 2003 2:07 pm    Post subject: Re: How to start On Fri, 5 Sep 2003 14:52:56 +0200, "Marek Ratajczak" <marek (AT) reset2 (DOT) pl> wrote: Quote: I know that I will have to rebuild all my application using new components and ideas. But I'm not sure which components shoud I choose. It depends on which database(s) you want to use. Quote: I've got D6. It seems to me, that I should use dbExpress components with DSP & CDS. Is this the best solution? I mean speed, stability etc. It depends on the database(s) you are going to use. Quote: Is it (in practice) possible to simply change DriverName in TSqlConnection to work with different sql servers? Unfortunately, SQL dialects vary greatly between database servers so it is not likely that you can support multiple databases with the same SQL statements unless they are very simple. If you need to support multiple database servers the two component choices are dbExpress and ADO. Quote: Which sql server should I choose? Licence prices are very important to my customers, so I would like to choose server, which is not too expensive. Is IB6 Open Source a good idea? Picking a database server is a complex process. You need to pick a server that supplies the features your app needs. If you can get a copy of the October 2000 Delphi Informant there is an article on choosing a database that may help. IB 6 open edition is no longer being developed so it is not, IMHO a good choice. -- Bill (TeamB) (TeamB cannot respond to questions received via email) Back to top Craig Stuntz [TeamB] Guest Posted: Fri Sep 05, 2003 2:11 pm    Post subject: Re: How to start Marek Ratajczak wrote: Quote: I have few years of experience with BDE, Paradox and TTables, but I'm quite new to sql servers. I know that I will have to rebuild all my application using new components and ideas. But I'm not sure which components shoud I choose. I've got D6. Here are some articles which should help: http://bdn.borland.com/article/0,1410,30019,00.html http://community.borland.com/article/0,1410,27194,00.html http://community.borland.com/article/0,1410,29106,00.html Quote: It seems to me, that I should use dbExpress components with DSP & CDS. Is this the best solution? I mean speed, stability etc. It might be. dbExpress gives you the ability to write applications which can support multiple DB servers with relative ease, but if you need access to features which are specific to one particular DB server then you will want to use components which are specific to your DB server. Quote: Is it (in practice) possible to simply change DriverName in TSqlConnection to work with different sql servers? Yes, but you have to ensure that your DBs have compatible metadata, and that can be some work, especially if you use a lot of stored procedures. There are also differences with how field types are mapped which are addressed in an open source extension to dbExpress. Quote: Which sql server should I choose? Licence prices are very important to my customers, so I would like to choose server, which is not too expensive. Nobody can answer this question for you without knowing more about your needs. I predict you'll get lots of replies stating that you should choose this server or that server, and I recommend you ignore them. You simply haven't provided enough information about what you're doing to give a good answer to the question. DB servers have features which make them better or worse for particular tasks. Quote: Is IB6 Open Source a good idea? It works well as it is. It's not being actively developed anymore, however. (*Commercial* IB, OTOH, is, and v7.1 was recently released.) If you're looking for a good DB to learn C/S development then IB Open Edition would be a fine choice. If you're developing a commercial product it might not be the best choice since it won't be enhanced in the future (although IB 7.1 might still be a candidate, depending upon your other needs). -Craig -- Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase PLANalyzer 1.1 -- Free InterBase query optimization tool: http://delphi.weblogs.com/IBPLANalyzer Back to top Aage Johansen Guest Posted: Mon Sep 08, 2003 9:01 pm    Post subject: Re: How to start On Fri, 5 Sep 2003 14:52:56 +0200, Marek Ratajczak <marek (AT) reset2 (DOT) pl> wrote:   Hello,   I have few years of experience with BDE, Paradox and TTables, but I'm quite new to sql servers. I know that I will have to rebuild all my application using new components and ideas. But I'm not sure which components shoud I choose. I've got D6. It seems to me, that I should use dbExpress components with DSP & CDS. Is this the best solution? I mean speed, stability etc. Is it (in practice) possible to simply change DriverName in TSqlConnection to work with different sql servers?   Which sql server should I choose? Licence prices are very important to my customers, so I would like to choose server, which is not too expensive. Is IB6 Open Source a good idea?     If you're just starting to learn Client/Server, IB6/OE is fine (and free). Depending on your "not too expensive" and your actual requirements, choosing a server for deployment may be less straightforward. Firebird is free, and the later IB versions are inexpensive - both can handle most tasks. If you just want to use these (Fb and IB) you can use components from IBO or FIBPlus (commercial middelware); with IB you can also use IBX, of course. I would only consider other components (like dbExpress) if I contemplated other servers (not Fb or IB). IB6/OE is, as you've seen, "not being actively developed anymore". I wouldn't plan on using it for the long haul. -- Aage J. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.