script files please help database data dump??

[johnnyboy23]

i have a sql 7 server for which i want to create a file or a script of some sort that ,when i use it will create all the tables and data on my new remote sql 7 server how do i go about doing this?

[parksie]

You can use SQL for this, with the CREATE TABLE statement. Are you upgrading from Access, or starting new? Microsoft have a free tool (I think it comes with 2000) to automatically upgrade you to a SQL Server project.

[johnnyboy23]

its for a client we need to creat an exact copy of our
sql7 database for them to put on there sql7 database
but operate seperatley
thanks
anyideas???????