database migration

Hi,
I wonder wether a software or a device (or script) allowing to migrate data
from an existant database to a new database by using correspondant ODBC
drivers existed.
Thanks for your help.How about BACKUP /RESTORE database commans
"ben" <bdugenet@.supralog.com> wrote in message
news:dqieie$rb$1@.news.tiscali.fr...
> Hi,
> I wonder wether a software or a device (or script) allowing to migrate
> data
> from an existant database to a new database by using correspondant ODBC
> drivers existed.
> Thanks for your help.
>

database migration

Hi,
I wonder wether a software or a device (or script) allowing to migrate data
from an existant database to a new database by using correspondant ODBC
drivers existed.
Thanks for your help.
Ben,
Why wouldn't you use possibilities that SQL Server gives you? You can use
backup / restore, Data Transformation Services, ...
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
"ben" <bdugenet@.supralog.com> wrote in message
news:dqieit$s5$1@.news.tiscali.fr...
> Hi,
> I wonder wether a software or a device (or script) allowing to migrate
> data
> from an existant database to a new database by using correspondant ODBC
> drivers existed.
> Thanks for your help.
>

Database migration

Hello,
Is it generally easier to migrate data from SQL Server to other
databases? I tried to find migration tools that would help move data
from SQL Server to other databases, and there were many. However,
trying to find tools that would migrate data from DB2, Oracle or any
other database to SQL Server was not really common. Is it harder to
migrate data to a SQL Server database? thank you.Moving data from Oracle, DB2 (and many other products) to SQL Server is
quite easy.
To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"contact1981" <contact1981@.gmail.com> wrote in message
news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
> Hello,
> Is it generally easier to migrate data from SQL Server to other
> databases? I tried to find migration tools that would help move data
> from SQL Server to other databases, and there were many. However,
> trying to find tools that would migrate data from DB2, Oracle or any
> other database to SQL Server was not really common. Is it harder to
> migrate data to a SQL Server database? thank you.
>|||Hi,
Migration to SQL is easy, just get the migration toolkit from microsoft sit
e.
'SQL Server Migration Assistant' this tool will automate most of the phases
of the migration process. or u can use DTS .
Amol Lembhe
"Arnie Rowland" wrote:

> Moving data from Oracle, DB2 (and many other products) to SQL Server is
> quite easy.
> To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "contact1981" <contact1981@.gmail.com> wrote in message
> news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
>
>|||I think the shortage of third-party migration tools for converting to
SQL Server is because, as others have noted, Microsoft already had the
tools you need "in the box" or free to download.
Roy
On 7 Aug 2006 08:59:11 -0700, "contact1981" <contact1981@.gmail.com>
wrote:

>Hello,
>Is it generally easier to migrate data from SQL Server to other
>databases? I tried to find migration tools that would help move data
>from SQL Server to other databases, and there were many. However,
>trying to find tools that would migrate data from DB2, Oracle or any
>other database to SQL Server was not really common. Is it harder to
>migrate data to a SQL Server database? thank you.

database migration

Hi,

I wonder wether a software or a device (or script) allowing to migrate data
from an existant database to a new database by using correspondant ODBC
drivers existed.

Thanks for your help.Hello Ben,

> I wonder wether a software or a device (or script) allowing to migrate
data
> from an existant database to a new database by using correspondant ODBC
> drivers existed.

Yes, there's such software.

Try our tool, Database Workbench, at www.upscene.com

Here's some info on the Schema Migrator:
http://www.upscene.com/documentatio...emamigrator.htm

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com|||ben wrote:
> Hi,
> I wonder wether a software or a device (or script) allowing to migrate data
> from an existant database to a new database by using correspondant ODBC
> drivers existed.
> Thanks for your help.

Do you have some specific problem in mind or is this just a general
enquiry? There are many, many solutions that exist to migrate data
between different data sources. I've included a few links below.
Whether you'll want any of the third party products depends on your
budget and how sophisticated your requirements are.

If you are using SQL Server then first take a look at either using a
linked server or DTS (SQL Server 2000) or Integration Services (SQL
Server 2005). Information on those features can be found in Books
Online.

http://www.microsoft.com/sql/techno...on/default.mspx
www-306.ibm.com/software/data/integration/dis/
www.abinitio.com
www.datamirror.com
www.datawatch.com
www.embarcadero.com/products/dtstudio/index.html
www.informatica.com
www.pervasive.com/solutions/

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--