How to extract data from one database to another.

[Tom Frank]

Hi,

Anybody have an idea of copying data from tables of a database to another
database. It should be a choice to select all tables, single table or
several tables.

For them knowing Oracle it is possible to do it with 'exp', where you can
choose to script the database with or without data. So I am trying to get
alike to MSSQL. The job is to unload data from a database with one
structure to another database with another structure.

Thanks in advance

Best regards
Tom Frank

[Simon Hayes]

"Tom Frank" <to****@hotmail.com> wrote in message
news:40*********************@dread12.news.tele.dk. ..

Hi,

Anybody have an idea of copying data from tables of a database to another
database. It should be a choice to select all tables, single table or
several tables.

For them knowing Oracle it is possible to do it with 'exp', where you can
choose to script the database with or without data. So I am trying to get
alike to MSSQL. The job is to unload data from a database with one
structure to another database with another structure.

Thanks in advance

Best regards
Tom Frank

If both databases are on the same server, then INSERT ... SELECT ... is
fastest:

INSERT INTO dbo.ThisTable
(col1, col2, ...)
SELECT col1, col2, ...
FROM ThatDatabase.dbo.ThatTable

If the databases are on different servers, then you can check out bcp.exe or
DTS. bcp.exe dumps/loads table data (or the results of a query) to/from a
flat file; DTS is an ETL tool, which is useful for more complex operations,
but the Import and Export Data wizard can quickly create a basic package for
copying data.

Simon

[Thomas]

"Tom Frank" <to****@hotmail.com> wrote in message news:<40*********************@dread12.news.tele.dk >...

Hi,

Anybody have an idea of copying data from tables of a database to another
database. It should be a choice to select all tables, single table or
several tables.

For them knowing Oracle it is possible to do it with 'exp', where you can
choose to script the database with or without data. So I am trying to get
alike to MSSQL. The job is to unload data from a database with one
structure to another database with another structure.

Thanks in advance

Best regards
Tom Frank

Hi, use SQL-Scripter to copy your data.
http://www.sqlscripter.com

Best regards,
Thomas

[Sheetal Verghese]

Hello,

I am trying to convert a single code page MS Server database into a unicode
database, using the unicode data types,NCHAR, NVARCHAR, NTEXT. The problem
is that in the original database, indexes and constraints have been defined
on the tables whose configuration needs to be changed. As a result, the
ALTER TABLE command fails. Are there any other alternative solutions?

It would be great if you could help!

Thanks,

Sheetal.

[Sheetal Verghese]

Hello,

I am trying to convert a single code page MS Server database into a unicode
database, using the unicode data types,NCHAR, NVARCHAR, NTEXT. The problem
is that in the original database, indexes and constraints have been defined
on the tables whose configuration needs to be changed. As a result, the
ALTER TABLE command fails. Are there any other alternative solutions?

It would be great if you could help!

Thanks,

Sheetal.