[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Visual FoxPro 9 tables to SQL Server 2005 tables!

Ioannis Stefis

3/24/2007 9:06:00 AM

Hi to all!

How can I transform my Visual FoxPro 9 tables in SQL Server 2005 tables?

Thanks in advance
4 Answers

David Portas

3/24/2007 9:49:00 AM

0

On 24 Mar, 09:05, "Ioannis Stefis" <stef...@otenet.gr> wrote:
> Hi to all!
>
> How can I transform my Visual FoxPro 9 tables in SQL Server 2005 tables?
>
> Thanks in advance

You can use Integration Services (SSIS), assuming you installed that
with SQL Server. Either create a SSIS package yourself using BI
Development Studio or use the Import Wizard (right-click the database,
select Tasks, select Import Data).

There are a few things that FoxPro allows but SQL Server doesn't:
empty dates, dates earlier than 1753 and numeric values out of range
for example. So watch out for those issues.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/librar...(en-US,SQL.90).aspx
--

David Portas

3/24/2007 9:53:00 AM

0

On 24 Mar, 09:05, "Ioannis Stefis" <stef...@otenet.gr> wrote:
> Hi to all!
>
> How can I transform my Visual FoxPro 9 tables in SQL Server 2005 tables?
>
> Thanks in advance

I should also mention that FoxPro has an Upsizing Wizard to do the
same job. If it is just a one-off exercise then you may want to use
the Upsizing Wizard. On the other hand if you need a repeatable
process or want to do the conversion without FoxPro then use SSIS.

Note that upsizing by any method is no substitute for a review and
redesign. A schema that made sense in FoxPro won't necessarily be as
effective in the SQL world.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/librar...(en-US,SQL.90).aspx
--

Ioannis Stefis

3/24/2007 5:40:00 PM

0

I use the SQL Server express edition. I cannot see the options you
mentioned!

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:1174729984.201445.187550@e65g2000hsc.googlegroups.com...
> On 24 Mar, 09:05, "Ioannis Stefis" <stef...@otenet.gr> wrote:
> > Hi to all!
> >
> > How can I transform my Visual FoxPro 9 tables in SQL Server 2005
tables?
> >
> > Thanks in advance
>
> I should also mention that FoxPro has an Upsizing Wizard to do the
> same job. If it is just a one-off exercise then you may want to use
> the Upsizing Wizard. On the other hand if you need a repeatable
> process or want to do the conversion without FoxPro then use SSIS.
>
> Note that upsizing by any method is no substitute for a review and
> redesign. A schema that made sense in FoxPro won't necessarily be as
> effective in the SQL world.
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/librar...(en-US,SQL.90).aspx
> --
>

David Portas

3/25/2007 7:37:00 AM

0

On 24 Mar, 18:39, "Ioannis Stefis" <stef...@otenet.gr> wrote:
> I use the SQL Server express edition. I cannot see the options you
> mentioned!
>

Express doesn't have SSIS.

Upsizing Wizard:
http://msdn2.microsoft.com/en-us/librar...(VS.80).aspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/librar...(en-US,SQL.90).aspx
--