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?
Printable View
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?
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.
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???????