Need a Sql Scriptor

I need to generate the Sql Scripts for a particular Database in a Sql Server 7.0.

Also i need help in the Data Migration of Foxpro2.6a to SqlServer.

If there are any good tools for such conversion,I am very much thankful to all who comes with a good reply.

Thanks & Regds,
B.SethuJust right click any of your databases and choose "all tasks" then "generate sql scripts". If you have an odbc driver for the foxpro database then you can use the dts import wizard. If not, just export the foxpro database to a delimited file and use the wizard.|||To migrate your data look into Distributed Transaction Coordinator (DTS),which comes with SQL Server. Also use Google (http://www.google.com) to research on the migration.|||Thanks for the reply.I need to create Insert Statements for all my Master Tables(say 1000).I need a tool which gives me the insert statements,either if i give the Database or Tables of the Database.

Also for foxpro we don't have any ODBC driver,moreover my all foxpro tables have memo fields,which i can't transform via DTS.

Thanks & Regds,
B.Sethu|||To generate the scripts for all of your databases you can use the sql-dmo script method - look at your books online.

What happens when you try to transform the foxpro table with a memo field ?|||I've created a stored procedure that will generate the INSERT statements

Example in Pubs database
exec usp_CreateInsert authors

INSERT authors ( au_id, au_lname, au_fname, phone, address, city, state, zip, contract)
VALUES ('409-56-7008','Bennet','Abraham','415 658-9932','6223 Bateman St.','Berkeley','CA','94705',1)
INSERT authors ( au_id, au_lname, au_fname, phone, address, city, state, zip, contract)
VALUES ('427-17-2319','Dull','Ann','415 836-7128','3410 Blonde St.','Palo Alto','CA','94301',1)

I've attached the script|||For the foxpro conversion - have you tried converting to access first then to sql server ?