Very Computer

Hi,

If any body can help me out by providing sample code for migrating data
and also database objects ( Roles, Indexes, Realtionship etc) from
Pervasive SQL 2000 to MS-SQL 2000 using VC++/ADO technologies.

This is a very huge database of last 20yrs record.

Please provide it asap.

I'm totally a fresher to database applications. So please help me out
regarding this.

Thanx,
Subrat

--
Posted via http://dbforums.com

Cannot say anything particular about compatibility of datatypes, but I think
you could look into SQL DTS, which comes with SQL Server. That tool allows
to transfer data between different datasources. I think it will be main tool
in your case to import data from Pervasive into SQL Server

--
Val Mazur
Microsoft MVP

Quote:

> Hi,

> If any body can help me out by providing sample code for migrating data
> and also database objects ( Roles, Indexes, Realtionship etc) from
> Pervasive SQL 2000 to MS-SQL 2000 using VC++/ADO technologies.

> This is a very huge database of last 20yrs record.

> Please provide it asap.

> I'm totally a fresher to database applications. So please help me out
> regarding this.

> Thanx,
> Subrat

> --
> Posted via http://dbforums.com

Hi Val Mazur,

Thanks for your support. But my work does not allow me to use any wizard
includind DTS. I've to do it through code only that to using VC++.

So I kindly request you to provide me sample code to transfer the data
as well as common database objects.

Thanks in advance,
Subrat

--
Posted via http://dbforums.com

SQL DTS has COM model, which could be used from code. See some sample (on
VB, but you will get an idea)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q242377

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q242391

--
Val Mazur
Microsoft MVP

Quote:

> Hi Val Mazur,

> Thanks for your support. But my work does not allow me to use any wizard
> includind DTS. I've to do it through code only that to using VC++.

> So I kindly request you to provide me sample code to transfer the data
> as well as common database objects.

> Thanks in advance,
> Subrat

> --
> Posted via http://dbforums.com

Hi,

Thanks again. As far as data transfer is concened it is quite useful.
But what about common database objects, I mean Schema transfer.
 The article about DTS in microsoft site says

"DTS does not provide generic Object Transfer Manager features (the
creation of indexes, referential integrity constraints, defaults, and so
forth). DTS is designed only to manipulate and move data. Schema
definition and movement is not part of the specification or design of
the product."

So could you provide me some sample code to do so. It would be a great
help again.

Thanks in advance,
Subrat

--
Posted via http://dbforums.com

I do not know if there are any tools, which allows to provide full
migration, but I think easiest way to re-create schema is to generate
original scripts of table definitions from Pervasive and adjust them
manually to fit SQL Server. Then apply those scripts. If you will try to
write your own code, I think it will be huge amount of time, which could not
worth it

--
Val Mazur
Microsoft MVP

Quote:

> Hi,

> Thanks again. As far as data transfer is concened it is quite useful.
> But what about common database objects, I mean Schema transfer.
>  The article about DTS in microsoft site says

> "DTS does not provide generic Object Transfer Manager features (the
> creation of indexes, referential integrity constraints, defaults, and so
> forth). DTS is designed only to manipulate and move data. Schema
> definition and movement is not part of the specification or design of
> the product."

> So could you provide me some sample code to do so. It would be a great
> help again.

> Thanks in advance,
> Subrat

> --
> Posted via http://dbforums.com