MartyConnelly
martyconnelly at shaw.ca
Fri Apr 9 00:01:43 CDT 2004
I would work out and test proper backup and restores for that many databases. You will probably need some data dictionaries. Check your security for logon and SQL Injection attacks especially if you are exposing anything to the Net. Microsoft is running some training seminars on this, for the next couple of months, mostly for ASP.Net and VB.Net. 1. SQL Injection http://www.spidynamics.com/papers/SQLInjectionWhitePaper.pdf 2. Cross Site Scripting FAQ http://www.cgisecurity.com/articles/xss-faq.shtml 3. The Snort IDS http://www.snort.org 4. Advanced SQL Injection http://www.nextgenss.com/papers/advanced_sql_injection.pdf 5. SQL INjection http://www.securityfocus.com/infocus/1768#ref1 6. Secure Programming HOWTO, David Wheeler www.dwheeler.com 7. Threats and Countermeasures, MSDN, Microsoft http://msdn.microsoft.com Martin Reid wrote: >Have it. LOL he was the technical on one of ours as well. (<: > >I am doing some work for a company and am really interested in opinions from >developers on various topics to do with moving from Access to SQL Server. >This company are currently putting a lot of focus on that particular subject >and I mean a lot of focus on how to do it, how to manage the process etc >Seems to be a big topic there at the moment for whatever reason. > >>From my side I am looking at management and change issues involved in the >process of moving up perhpas an entire companys Access database load over to >SQL Server. ie. You have moved to SQL > Server now what do you do? > >Martin > > > >----- Original Message ----- >From: "Francisco H Tapia" <my.lists at verizon.net> >To: <dba-sqlserver at databaseadvisors.com> >Sent: Thursday, April 08, 2004 9:09 PM >Subject: Re: [dba-SQLServer] OLEDB > > > > >>Martin Reid said the following on 4/8/2004 12:24 PM: >> >> >> >>>You have moved your databases up to SQL Server. What would you use for >>> >>> >the > > >>>front end connection, for example would you change to OLEDB?? >>> >>> >>> >>> >>hmmm... I'm gonna refer you to a good book :)... it's called From Access >>to Sql Server from Ruselle Sinclair. ;o) >> >>As I understand it OLEDB is the connectivity of choice for Sql Server. >>It certainly is easier and more clearer in coding practice. >>I don't anticicpate any benefits by choosing ODBC connectivity. >> >>-- >>-Francisco >> >> >>_______________________________________________ >>dba-SQLServer mailing list >>dba-SQLServer at databaseadvisors.com >>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >>http://www.databaseadvisors.com >> >> >> >> > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > > > > -- Marty Connelly Victoria, B.C. Canada