Select your font size  A  A  A 
 
about us products & services consulting & support news & events contact us

Database Programming - New Brunswick
print this article 
 

This page is about Transparen's capabilities with respect to databases. To learn about Transparen's capabilities with respect to general custom programming, click here.

Our experience with database programming includes:

  • Designing and developing an N-Tier COM web service application that interfaces with MS SQL Server for a government client
  • Creating an e-commerce site with MySQL database back-end for a financial services client
  • Database extraction from a large DB2 mainframe for data analysis
  • Migrating databases from one application to another
  • Systems integration between databases

Transparen Corporation provides database data recovery services as well, such as recovering after system tables have been damaged after a hard drive crash or near crash experience. Databases that we can recover from include:

  • MS Exchange
  • MS SQL Server
  • MySQL
  • Postgresql
  • DB2
  • MaxDB
  • Oracle
  • Access
  • Outlook's email database

Most modern programming involves some sort of interaction with a database, even if the database is as simple as plain text files in a directory structure (yes, even that can be considered a database!). For instance, companies often require the following types of database-enabled applications:

  • Client database - for maintaining a unique identity for people who do business with the company.
  • Transaction database - for keeping track of what transactions have been initiated or completed
  • Subscription database - for allowing current subscribers to have access to certain benefits
  • Support ticket database - this allows companies to see what kinds of issues come up more frequently, and allows technicians to share their knowledge

Transparen offers support for Open Source software, such as the following two popular Open Source databases:

  • MySQL
  • Postgresql

The main difference between MySQL and Postgresql is that MySQL is faster for development, but Postgresql contains more enterprise features such as ACID compliant transactions, the ability to write procedures, support for foreign keys, and more.

Other Open Source databases include:

  • Firebird (not to be confused with FireFox, the web browser)
  • Ingres

  

Most Recent Website and Regional Updates

 
 Advantages of Remote Desktop Support
1. You get more for less. 2. We can work when you're not using the computer. 3. Your staff will be more productive. 4. You avoid many expensive repair situations by fixing problems earlier. 5. 24/7 Support!
 
 Online Software for Management of Trade Journal Web-Based Order Fulfilment
Savvy Trade Journal Publishers know that future-oriented professionals need to stay cutting-edge. Offering information in the online format speeds delivery while cutting costs.
 
 Simplicity is Key to Success in Web Publishing
Publishers make their own systems to remove unnecessary complexity, but later get stuck on a treadmill of bugfixes and incomplete features. We offer the simple, easy and complete solution.
 
 Focusing on Paying Customers Improves Bottom Line
Built-in credit card processing and automatic renewals are just some of the features that make Transparen's solution a winner.
 
 Online Magazine Sales and Distribution System
Turnkey publishing system facilitates easy online recurring billing, content delivery. Publish using the same software as you use for the print edition.
 
 World-Class Online Magazine Software Is Affordable - Guaranteed
Being an entrepreneur is risky, and entrepreneurs hate risk. We have a pricing model that allows your magazine to grow quickly, without worrying about putting forward too much cash up front.
 
 Online Magazine Site Customization
Need a finely-honed tool custom-made for unique requirements? Don't sweat the small stuff - Transparen has it done, and can focus on unique innovative and insightful new features, without having to reinvent the wheel.
 
 Respond to More RFPs (Requests for Proposals)
Respond to more proposals by outsourcing some of your RFP response processes to Transparen's technical writing team, and benefit from Canadian technical writers who understand technology and its business applications.
 
 RFI (Request for Information) Response Service
Outsource your RFI response process to Transparen's technical writing team in Surrey, British Columbia, Canada.
 
 Website Graphic Design, By Transparen
Creating css-based, compatible, yet beautiful and functional, attractive and maintainable websites since 2003.
 
 

E C M | © 2003-2007 Transparen Corp.      

Standardized Services: Data Recovery Service / Creative Services / Premium Web Hosting Services / System Administration Tech Support Services
Recent Projects: Full-Service Mortgage and Financing Company / System to manage flights from Vancouver to Tofino
* Alma * Aroostook * Atholville * Baker Brook * Balmoral * Bas Caraquet * Bath * Bathurst * Belledune * Beresford * Bertrand * Blacks Harbour * Blackville * Bouctouche * Bristol * Cambridge-Narrows * Campbellton * Canterbury * Cap Pélé * Caraquet * Centreville * Charlo * Chipman * Clair * Dalhousie * Dieppe * Doaktown * Dorchester * Drummond * Edmundston * Eel River Crossing * Florenceville * Fredericton * Fredericton Junction * Gagetown * Grand Bay-Westfield * Grand Falls * Grand Manan * Grande-Anse * Hampton * Hartland * Harvey * Hillsborough * Kedgwick * Lac Baker * Lameque * Le Goulet * Maisonnette * McAdam * Meductic * Memramcook * Millville * Minto * Miramichi * Moncton * Nackawic * Neguac * New Maryland * Nigadoo * Norton * Oromocto * Paquetville * Perth-Andover * Petitcodiac * Petit Rocher * Plaster Rock * Pointe-Verte * Port Elgin * Quispamsis * Rexton * Richibucto * Riverside-Albert * Riverview * Riviere-Verte * Rogersville * Rothesay * Sackville * Saint-Andre * Saint-Antoine * Saint-François-de-Madawaska * Saint-Hilaire * Saint-Isidore * Saint John * Saint-Leolin * Saint-Leonard * Saint-Louis-de-Kent * Saint-Quentin * Sainte-Anne-de-Madawaska * Sainte-Marie - Sainte-Raphael * Salisbury * Shediac * Shippagan * Stanley * St. Andrews * St. George * St. Martins * St. Stephen * Sussex * Sussex Corner * Tide Head * Tracadie-Sheila * Tracy * Woodstock * Aberdeen * Aboujagane * Acadie * Acadie Siding * Acadieville * Adams Gulch * Adamsville * Addington * Albert Mines * Albrights Corner * Alcida * Alderwood * Aldouane * Allainville * Allardville * Allison * Ammon * Anagance * Anderson Road * Anderson Settlement * Andersonville * Anfield * Anse-Bleue * Apohaqui * Arbeau Settlement * Armond * Arthurette * Ashland * Astle * Aulac * Avondale * Back Bay * Baie-Ste-Anne * Baie Verte * Barryville * Bartibog Bridge * Bates Settlement * Bay du Vin * Bayside * Beaubassin East * Beaverbrook * Beaver Dam * Bellefleur * Benjamin River * Berwick * Bettsburg * Big Hole * Big River * Black River * Black River Bridge * Blair Athol * Blissfield * Blissville * Bloomfield * Bloomfield Ridge * Boiestown * Bocabec * Brantville * Brockway * Browns Flat * Bull Lake * Burnsville * Burnt Church * Burton * Burtts Corner * Cains River * Campbell Settlement * Campobello Island * Canton des Basques * Caron Brook * Carrolls Crossing * Casillis * Caverhill * Chamcook * Chatham * Chatham Head * Chelmsford * Clarkville * Cloverdale * Cocagne * Coles Island * Collette * Connors * Cornhill * Coteau Road * Dalhousie Junction * Daulnay * Dawsonville * Debec * Deer Island * Derby * Devereaux * Douglas * Douglastown * Dugas * Duguayville * Dumfries * Dundee * Dunlop * Durham Bridge * Eel Ground * Elgin * Escuminac * Evandale * Évangéline * Fairisle * Fairvale * Five Fingers * Flatlands * Four Falls * Gauvreau * Geary * Glassville * Glencoe * Glen Levit * Glenwood * Gondola Point * Grafton * Grande-Digue * Gravel Hill * Gray Rapids * Hainesville * Hampstead * Hanwell * Hardwicke * Hartfield * Hatfield Point * Haut-Lamèque * Haut-Sheila * Havelock * Hawkshaw * Hazeldean * Head of Millstream * Health Steele * Hebron * Honeydale * Howard * Hoyt * Inkerman * Jacquet River * Janeville * Jemseg * Johnsville * Juniper * Keswick Ridge * Kingsclear * Kingston * Kouchibouguac * Lagacéville * Lake George * Lakeville * LaPlante * Lavillette * Lawrence Station * Limestone * Loggieville * Lorne * Losier Settlement * Lower Newcastle * Ludlow * Mactaquac * Madran * Magaguadavic Settlement * Magundy * Maltampec * Maple Ridge * Marysville * Maugerville * McGivney * McGraw Brook * McLeods * McNamee * Menneval * Millerton * Miramichi Bay * Miscou Island * Moulin-Morneault * Napadogan * Napan * Nash Creek * Nashwaak Bridge * Nashwaak Village * Nasonworth * Nauwigewauk * Nelson * Nelson Hollow * New Bandon * New Denmark * New Jersey * New Mills * Nicolas-Denys * Noonan * Nordin * North Head * North Tetagouche * Northampton * Notre-Dame * Notre-Dame-de-Lourdes * Notre-Dame-des-Érables * Oak Bay * Odell * Otis * Oxbow * Pabineau Falls * Parker Ridge * Pembroke * Penniac * Penobsquis * Petite-Lamèque * Petite-Rivière-de-l'Ile * Petite-Tracadie * Pigeon Hill * Pinder * Pocologan * Point La Nim * Pointe-à-Bouleau * Pointe-Alexandre * Pointe-Canot * Pointe-Sapin * Pokemouche * Pokeshaw * Pokesudie * Pokiok * Pont-Lafrance * Pont-Landry * Porten * Priceville * Prince William * Quarryville * Queensbury * Quisbis * Red Bank * Renforth * Renous * Richibouctou-Village * Riley Brook * Ripples * Riviere-du-Portage * Robertville * Robinsonville * Rosaireville * Rossville * Rough Waters * Saint-Arthur * Saint-Basile * Saint-Charles * Saint-Ignace * Saint-Irenée * Saint-Jacques * Saint-Jean-Baptiste-de-Restigouche * Saint-Joseph-de-Madawaska * Saint-Laurent * Saint-Martin-de-Restigouche * Saint-Maure * Saint-Sauveur * Saint-Simon * Sainte-Louise * Sainte-Marie-de-Kent * Sainte-Rose * Salmon Beach * Saumarez * Scotch Lake * Seal Cove * Sevogle * Shannonvale * Sheffield * Shemogue * Siegas * Sillikers * Sisson Ridge * Southampton * South Tetagouche * Springfield * Squaw Cap * St. Margarets * Stickney * Strathadam * Stonehaven * Sunny Corner * Tabusintac * Targettville * Taxis River * Taymouth * Temperance Vale * Tetagouche Falls * Tilley * Tracadie Beach * Tremblay * Upper Blackville * Upper Kent * Upper Queensbury * Upsalquitch * Val-Comeau * Val-d'Amour * Val-Doucet * Verret * Village-Blanchard * Village-Saint-Laurent * Waterville * Wayerton * Weaver Siding * Welsford * Westfield * White Rapids * Whites Cove * Wicklow * Williamstown * Wilsons Beach * Wirral * Zealand * Aberdeen * Acadieville * Addington * Allardville * Alma * Alnwick * Andover * Baker Brook * Balmoral * Bathurst * Beresford * Blackville * Blissfield * Blissville * Botsford * Bright * Brighton * Brunswick * Burton * Cambridge * Campobello * Canning * Canterbury * Caraquet * Cardwell * Carleton * Chatham * Chipman * Clair * Clarendon * Colborne * Coverdale * Dalhousie * Denmark * Derby * Dorchester * Douglas * Drummond * Dufferin * Dumbarton * Dumfries * Dundas * Durham * Eldon * Elgin * Gagetown * Gladstone * Glenelg * Gordon * Grand Falls * Grand Manan * Greenwich * Grimmer * Hammond * Hampstead * Hampton * Harcourt * Hardwicke * Harvey * Havelock * Hillsborough * Hopewell * Huskisson * Inkerman * Johnston * Kars * Kent * Kingsclear * Kingston * Lac-Baker * Lepreau * Lincoln * Lorne * Ludlow * Madawaska * Manners Sutton * Maugerville * McAdam * Moncton * Musquash * Nelson * New Bandon * New Maryland * Newcastle * North Lake * Northampton * Northesk * Northfield * Norton * Notre-Dame-de-Loudres * Paquetville * Peel * Pennfield * Perth * Petersville * Prince William * Queensbury * Richibucto * Richmond * Rivière-Verte * Rogersville * Rothesay * Sackville * Saint Andrews * Saint Croix * Saint David * Saint George * Saint James * Saint Martins * Saint Mary * Saint Marys * Saint Patrick * Saint Stephen * Saint-André * Saint-Basile * Saint-Charles * Saint-François * Saint-Hiliare * Saint-Isidore * Saint-Jacques * Saint-Joseph * Saint-Louis * Saint-Léonard * Saint-Paul * Saint-Quentin * Sainte-Anne * Salisbury * Saumarez * Shediac * Sheffield * Shippagan * Simonds, Carleton County * Simonds, Saint John County * Southampton * Southesk * Springfield * Stanley * Studholm * Sussex * Upham * Wakefield * Waterborough * Waterford * Weldford * Wellington * West Isles * Westfield * Westmorland * Wickham * Wicklow * Wilmot * Woodstock