Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Binod Binani
  Where is Binod Binani?
 Kolkata
 India
 Binod Binani
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Creating database in SQL Exp
Thread ID: 268740 Message ID: 268938 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, July 15, 2010 2:41:43 PM         
   


> > Dear Expert,
> >
> > For a new project,I had created a new database in vfp native data. Further I had
> > created a prg ie "NEWDBC.PRG" using GENDBC(). Now i wish to create database in
> > SQL Server Exp. using 'newdbc.prg'. Is it possible?. Or is there is some another
> > way so that i need not to create tables mannualy using SQL Server Management Studio.
> >
> > Please Help.
> >
> > TIA
> >
> >
> > *Exchange of $1 Create only $1, But Exchage of one Ideas Makes different two Ideas*
>
> Use the Upsizing Wizard in Tools->Wizards.
> The code in that GenDBC creates with CREATE DATABASE and CREATE TABLE has to be editid. SQL Server does use one-letter acronyms like C, T, V, N, and D to indicate data types.
>
> Install SQL Server's reference and help BooksOnLine, BOL, from Microsofts' Download Center at http://www.microsoft.com/downloads/details.aspx?FamilyID=765433f7-0983-4d7a-b628-0a98145bcb97&displaylang=en
>
> Anders

Thanx Sir. Nice Link. Let me try it.


*Exchange of $1 Create only $1, But Exchage of one Ideas Makes different two Ideas*

ENTIRE THREAD

Creating database in SQL Exp Posted by Binod Binani @ 7/14/2010 10:29:09 AM
RE: Creating database in SQL Exp Posted by tushar @ 7/14/2010 10:58:43 AM
RE: Creating database in SQL Exp Posted by Binod Binani @ 7/15/2010 2:40:45 PM
RE: Creating database in SQL Exp Posted by Binod Binani @ 7/19/2010 11:29:35 AM
RE: Creating database in SQL Exp Posted by Binod Binani @ 7/19/2010 11:35:59 AM
RE: Creating database in SQL Exp Posted by Binod Binani @ 7/19/2010 12:36:08 PM
RE: Creating database in SQL Exp Posted by Anders Altberg @ 7/14/2010 11:05:09 AM
RE: Creating database in SQL Exp Posted by Binod Binani @ 7/15/2010 2:41:43 PM