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

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
--