About Blog Forums Buy It Try It See It Home Compare Screenshots Features Tutorials Testimonials Try Gibraltar Using SQL Server Integration Services to Migrate VistaDB 4 Data VistaDB.Net Try It Tutorials Using SQL Server Integration Services to Migrate VistaDB 4 Data An earlier post talked about how to use the SQL Server Import Wizard to get data into SQL Server from VistaDB You can use that Wizard to build DTS-like packages They are called dtsx files in SQL Server 2008, but are actually run by SQL Server Integration Services But that process is a bit cumbersome and only works one table at a . time You also lose null rows , foreign keys and check constraints . There is a better way , but it involves a LOT more work build an SSIS . package SSIS packages are Integration Services Projects You
About Blog Forums Buy It Try It See It Home Compare Screenshots Features Tutorials Testimonials Try Gibraltar How to use generic ADO.NET data factories to load a database VistaDB.Net Try It Tutorials Using Generic ADO.NET Data Factories Too many samples on the internet only show how to write ADO.Net code for their chosen provider , none really cover the fact that ADO requires a generic factory interface that can make changing database backends as simple as modifying a single file . This allows for any number of database backends to be used , as long as they all support the same SQL syntax , or are close enough that simple type checks can be used to alter the syntax on the . fly The example below shows how to create a generic connection and execute a command using only the connection string
Log in Database Geek Blog Database Stuff , from a Geek Home About Feeds Subscribe to Feed Hilarious Ad Post Collision Posted in December 16, 2010 10:05 . pmh Lewi No Comments I stopped by my blog today to upgrade the version of wordpress and some plug-ins . On the front page I got this hilarious ad and it seemed to really be appropriate to the very silly post it was shown . with So a geek walks into a bar I wrote a very silly post about a data architect and a biz guy really silly geek humor and the ad is Why can’t I get a date Maybe because you’re looking in the wrong place . 8221 . Ahahahahaha Sorry . That just cracked me up . When I refreshed , I got an ad for ETL software . I have no idea what the relationship between the post and the geek dating ad is but I found the collision .
Team Leadership QuickBase News Tips Tricks Customer Stories Industry Trends Inside QuickBase Partner Corner Filling Out Surveys Pays Off Survey Feedback Incorporated Into Upcoming Release By Ellie Ellerman Posted on December 16th , 2010 Share Tweet A little while ago , I asked some of you our customers to fill out a product feature survey . The goals of the survey were to assess your interest in adding collaboration features to QuickBase vs . other features and to also understand key aspects of how your teams use QuickBase . About 250 of you responded to the survey thank you and gave us some very interesting insight into your priorities as QuickBase users and team members . I thought I’d share a few of the highlights and let you know how we’re using your feedback to make QuickBase . better
About Blog Forums Buy It Try It See It Home Compare Screenshots Features Tutorials Testimonials Try Gibraltar Microsoft MVP Program Supporting the Microsoft Development Community VistaDB.Net Purchase VistaDB Microsoft Most Valuable Professional Program At Gibraltar Software , we believe our relationship with the technical community is incredibly important , and so we participate in Microsoft's MVP NFR Program to show our respect for the valued and prominent members of the NET community who generously share their expertise as Microsoft Most Valued . Professionals Microsoft MVPs have clear ideas and opinions about the technologies they work with and , over time , we hope that they come to know enjoy Gibraltar Software and our products . We offer Microsoft MVPs the chance to use and reviewAbout Blog Forums Buy It Try It See It Home Compare Screenshots Features Tutorials Testimonials Try Gibraltar How We Help MicroISVs Succeed Discounted Pricing for MicroISVs and Independent Consultants VistaDB.Net Purchase VistaDB MicroISV Program We know what it's to be a scrappy , cash-starved start-up . We understand intimately having been there ourselves . Tool selection is agonizing because you want world-class tools that make you productive and ensure high quality products for your customers but you really need affordable pricing to make the numbers . work To help small companies be successful , we offer discounted pricing licenses to small startups and independent consultants for VistaDB and other Gibraltar Software . products If you participate in Microsoft BizSpark we want to help
About Blog Forums Buy It Try It See It Home Compare Screenshots Features Tutorials Testimonials Try Gibraltar Using SQL Server Import and Export Wizard with VistaDB VistaDB.Net Try It Tutorials Using SQL Server Import and Export Wizard with VistaDB We're sometimes asked , how can you use the SQL Server Import and Export Wizard to migrate data from VistaDB 4 to SQL Server 2008 Using DTSWizard Take a look at the property for the shortcut from your start menu . 160 If should point somewhere like C : Program Files Microsoft SQL Server 100 DTS Binn DTSWizard.exe Launch the DTSWizard . The VistaDB provider will show up in the list of Providers you can choose in the source database step only on machines where it is installed of course Select the in the Data Source row to go and find your database
About Blog Forums Buy It Try It See It Home Compare Screenshots Features Tutorials Testimonials Try Gibraltar ADONET Data Services with VistaDB for Quick Client Server Applications VistaDB.Net Try It Tutorials ADO.NET Data Services with VistaDB for Quick Client Server Applications We get questions from users asking how they can build client server solutions using VistaDB , or more often just how they can avoid having to share drive letters to share a database . The traditional answer in the past has been to build a simple data access layer DAL and expose it over SOAP or WCF . Now with ADO.NET Data Services and our Entity Framework EF provider you have another . choice ADO.NET Data Services Astoria Not familiar with the codename Project Astoria was released with Net 3.5 SP1 under the