Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server Migration Assistant (SSMA) tools to migrate non-MSSQL databases

SQL Server Migration Assistant in short SSMA is the migration toolkit that can be used to migrate the databases from Oracle, Sybase, Access and now MySQL too. The recent announcement of SSMA for MySQL is available for download, SSMA reduces the manual...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 22 2010
Filed under: Filed under: sql server, tools, database, mysql, oracle, sybase, ssma, migration, code examples, database objects, power builder
Oracle's acquisition SUN brings cold shoulder to MySQL!

Its a old story that Oracle agreed to acquire Sun Microsystems, which means popular Open Source database application will be affected aka MySQL. As Sun already acquired MySQL in the previous year and a recent marriage of closed source database would get...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jan 1 2010
Filed under: Filed under: sql server, databases, microsoft, mysql, oracle, open source
Migration Solutions Center for SQL Server 2008

What is your biggest challenge when you need to upgrade a SQL Server 2008? Do you have a clear process of migrating non-SQL Server databases to SQL Server? Whatever is the reason or need to install SQL Server 2008 you must review the installation requirements...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Apr 2 2009
Filed under: Filed under: sql server, upgrade, BOL, documentation, access, process, oracle, sybase, ssma, migration, guidance
SQL Server Migration Assistant - what are the conversion rules between Oracle and SQL Server during the migration?

This was the big question posed by the users when a migration project is initiated at one of client's place. SQL_Server_Migration_Assistant is a must tool to asses the issues when you have a mammoth task of data migration between SQL Server and other...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Sep 9 2008
Filed under: Filed under: sql server, data, object, oracle, stored procedure, tables, ssma, migration, views, rules
How to handle PRAGMA AUTONOMOUS TRANSACTION mode within SQL Server?

The question on the subject was asked by one of the Data Integration project developers, which is initiated to migrate a database from Oracle to SQL Server. The process of transactions should be handled from Application and when it comes to the data migration...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Aug 28 2008
Filed under: Filed under: sql server, oracle, transactions, ssma, dtc, data-migration, autonomous, mode
SQL Server Migration Assistant tools from other data sources - 2005 & 2008 versions

From the blog of Technical Rollup mail that we receive from Microsoft here is the list of SQL Server Migration Assistant tools available from Microsoft to migrate/upgrade data from other data sources such as Access, Sybase & Oracle. _________________________________________________________________________________________________________________________...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Aug 4 2008
Filed under: Filed under: sql server, version, access, oracle, data sources, sysbase, migration assistant
FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: "OLE DB Provider 'OraOLEDB.ORACLE' for Linked server <LinkedServerName> returned message"

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you try to create an Oracle...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Aug 19 2007
Filed under: Filed under: sql server, replication, kba, service pack2, oracle, linked, publisher
Can't find linked server in management studio?

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 28 2007
Filed under: Filed under: sql server, management, security, server, ssms, enterprise, sql express, oracle, linked
Unique blog post I have ever seen that covers all RDBMS platforms

I was just browsing through the blogs on WordPress as it is one of my favourite blog sites, I came across this VanitiesForDBA post which is most amusing that the author 'coskan' has covered all major players in RDBMS technologies (MSSQL, Oracle...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jun 15 2007
Filed under: Filed under: sql server, mysql, oracle, sybase, db2
ELSASOFT giving out SQLSPEC for FREE to MVP

Read More...

Posted to SQL Server Citation - SQL Server Blog by Hemantgiri S. Goswami by on Wed, May 2 2007
Filed under: Filed under: sql server, MVP, dba, document, contributors, sqlspec, ace, sql server community, oracle, elsasoft, mct

Page 1 of 1 (10 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.