How to covert data from visual foxpro database to SQL server

Hi,
I have my data all store in visual foxpro
database, if i want to change my database to SQL server,
how do i copy all the data in visual foxpro and save in
SQL Server Database? Thank you.We are currently taking a lot of our data from Foxpro to SQL Server. We are
only taking Data and Structure. We simply used the Foxpro drivers and
created a link to the Foxpro DB. Using DTS we sucked the Data in. The
usual things are worth looking out for like Dates but besides that we have
no real problems with it.
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:696501c3437c$d5f33f40$a401280a@.phx.gbl...
> Hi,
> I have my data all store in visual foxpro
> database, if i want to change my database to SQL server,
> how do i copy all the data in visual foxpro and save in
> SQL Server Database? Thank you.|||The converse of this method is to create an SQL Server table to receive the
data and then create a remote view to that table on the FoxPro side. After
that you only need to APPEND FoxPro data to the view and issue a
TABLEUPDATE().
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@.mvps.org, www.cindywinegarden.com
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:e2klnp4QDHA.1564@.TK2MSFTNGP12.phx.gbl...
> We are currently taking a lot of our data from Foxpro to SQL Server. We
are
> only taking Data and Structure. We simply used the Foxpro drivers and
> created a link to the Foxpro DB. Using DTS we sucked the Data in. The
> usual things are worth looking out for like Dates but besides that we have
> no real problems with it.
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "florence" <florencelee@.visualsolutions.com.my> wrote in message
> news:696501c3437c$d5f33f40$a401280a@.phx.gbl...
> > Hi,
> >
> > I have my data all store in visual foxpro
> > database, if i want to change my database to SQL server,
> > how do i copy all the data in visual foxpro and save in
> > SQL Server Database? Thank you.
>