J Sure just dont use any 2000 functions If anyone is doing any seroius SQL development I'd suggest they look at xcase (www.xcase.com) it can generate an 'upgrade script' that preserves your data in about 1 minute
N ----- Original Message ----- From: "Jeremy Coulter" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 10:44 AM Subject: RE: [DUG]: Moving to MSDE > Oh, I only have access to SQLServer 2000, I guess that's ok? > > Jeremy > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Neven MacEwan > Sent: Tuesday, 7 October 2003 10:32 > To: Multiple recipients of list delphi > Subject: Re: [DUG]: Moving to MSDE > > > J > > Develop using SQL Server 7, Then you just install the MSDE package on > the client site, Network performance will always be better than an isam > even indexed > > N > > ----- Original Message ----- > From: "Jeremy Coulter" <[EMAIL PROTECTED]> > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> > Sent: Tuesday, October 07, 2003 10:24 AM > Subject: RE: [DUG]: Moving to MSDE > > > > Whats its performance like over a network? This is one area that > > DBISAM is not so flash. Well its OK, but I have a table that I have > > had to put 5 or is it 6 indexes onto to speed up querys that run in an > > > instant locally. > > > > Also, how exactly do you get started with MSDE? > > Do you basically do everything in SQLServer then export it? Maybe you > > have a site I can look at? > > > > Thanks, Jeremy > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > On Behalf Of Neven MacEwan > > Sent: Tuesday, 7 October 2003 10:21 > > To: Multiple recipients of list delphi > > Subject: Re: [DUG]: Moving to MSDE > > > > > > J > > > > Its v simple, In my experiance MSDE is indistinguishable from SQL 7 > > The one caveate is that some queries will run slower, they have > > removed some of the query opt stuff from MSDE, I use a kbmMemtable > > loaded from ADO and my own resolver > > > > Also if you want to manage an MSDE site we have an 'Enterprise > > manager' like tool which you are welcome to > > > > HTH > > > > Neven > > > > ----- Original Message ----- > > From: "Jeremy Coulter" <[EMAIL PROTECTED]> > > To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 07, 2003 9:49 AM > > Subject: [DUG]: Moving to MSDE > > > > > > > HI all. > > > At the moment I have a project where I am using the evaluation > > > version > > > > > of DBISAM. It does everything I want it to do, its fast compact, and > > > > I > > > > > REALLY like it ! > > > > > > BUT, after using MSSQL for so long, I miss stored proc.s and now > > > have a situation where a Stored Proc would solve a problem. I am > > > thinking that the move to MSDE might be an idea. Ok, its prob. a LOT > > > > of work, but really, I am wondering how well MSDE interacts with > > > Delphi, and if it IS worth it, um...hehehe....where do I start ? > > > hehehe > > > > > > > > > Cheers, > > > > > > Jeremy Coulter > > > > > > > > > -------------------------------------------------------------------- > > > -- > > > -- > > > All email scanned with Nortons Antivirus 2003 > > > > > ---------------------------------------------------------------------- > > -- > > > > > > > > > > ---------------------------------------------------------------------- > > -- > > --- > > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > ---------------------------------------------------------------------- > > ---- > - > > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > > Website: http://www.delphi.org.nz > > To UnSub, send email to: [EMAIL PROTECTED] > > with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > > ------------------------------------------------------------------------ > --- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > -------------------------------------------------------------------------- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
