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


> 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

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