import from microsoft sql server

[Georgiu Konstantinos]

Hello again,

>I do not understand this - you only can clone Valentina 2 databases -  
>not ODBC databases - 
>(at least not with vStudio).
With what could I do that? 

>So - what you mean with cloning here?
Look I am new to all this odbc-import/export thing. What I want to do is to import the whole odbc database(structure and data) from ms sql server to a valentina database.Is it possible? Importing the structure and the data isn't a way(type) of cloning the db?
Also (as I explain later) I would like to know if it is possible to read the data from an odbc database like the functionality that offers goldengate xtra (for director).

>This happens during IMPORT?
>Or during fetching of database structure?
1.During Connecting
This happens when I connect, when it tries to fetch the database structure. It fetches the tables and views correctly but it can't fetch any results (meaning data?). 
After these errors the database appears (as an odbc datasource) but when I try, for a table, to see the data (with open data editor) the same error occurs .(If I do the same second time the valentina studio crashes). So is it possible to fetch the data from an odbc connection? Can studio do that or this happens only when using the driver combined with a tool (like valentina for director, that is what i want) or it is possible only with an xtra like goldengate?

>Have you choosed to let Studio create all necessary tables for you?
How do I do it?

>Have you checked all new tables? Have you checked the field mappings  
>for each table?
>
>To isolate the problem it would be helpfull to know WHICH table and  
>WHICH fieldtypes causing it.
>Maybe it is possibel to import the tables ONE by ONE to see which one  
>causes the trouble?
2.importing the odbc database
So I try to import the database:
When i call import i can see the views and tables and i get to a screen asking me define the relationship between the fields of the source database and the new(valentina) database. So I create a table. Some fields get automatically the relationship with the source field(like int becomes Long  and varchar becomes VarChar). But for some fields that have types (like nvarchar) that exist only in microsoft's transact's-sql language there exists no mapping. Valetina Studio just ignores them. So do I have to create my own mappings?How do I do that? For example, if i have a table with 5 fileds of type int,varchar,int,nvarchar,nvarchar then after creating the table there are 3 fields with Long,VarChar,Long types and no nvarchar slots.


>And what "side tables" ?
Sorry, my mistake, It was the views that I thought were additional tables


>Another possibility to import data is to export them first to text- 
>files and importing these text-files using Valentina Studio#s Import  
>Wizard.

>-- 
>Best regards,
>Jochen Peters
>PIIT GmbH

>------------------------------------
>http://www.valentina-db.de

Thank you for your fast response and sorry for my english,
Kostas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 4285 bytes
Desc: not available
Url : http://edison.macserve.net/pipermail/valentina-studio/attachments/20070427/6c0db070/attachment.bin