Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jensmg
Starting Member
7 Posts |
 Posted - 2008-11-24 : 08:16:30
|
| Hello,we have a DB2 installed on a Linux machine. Is there a way to import the DB into a SQL 2005 Server cause we want to do some testing there.We also want to import a MaxDB into the SQL Server is there also a possibility?So is there a wizzard or something to do this import. I investigated the SQL Server but i cant find a import option for DB2 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 08:43:31
|
| you have different options1. if you consistent want connection between DB2 & SQL Server, Add DB2 serevr as a linked server to sql server. then you can access tables using four part naming convention select * from server.database.schema.objecthttp://msdn.microsoft.com/en-us/library/aa213778.aspx2. If its for adhoc transfer, use OPENROWSET or export import wizardhttp://msdn.microsoft.com/en-us/library/aa276850(SQL.80).aspxhttp://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm |
 |
|
|
jensmg
Starting Member
7 Posts |
Posted - 2008-11-24 : 09:39:03
|
| Thanks for the answer. We also want to do an import of a MaxDB into the SQL Server 2005. Is there also a tool for that ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 09:57:45
|
| Whats MaxDB? is it type of relational database? |
|
|
|
|
|
|
DB2 Import