July 17, 2008 at 4:41 am
I have used Access on several sites, the tables are uploaded just like the ASP or html files.
I can find my way around sql 2005 but cannot figure out how to get the tables I produce locally onto the server. Can someone point me in the direction of a book that explains this. I would also be prepared to pay someone who can write me a walkthru for it. I already have 4-5 books on SQL and they're excellent, but don't cover what I'm looking for.
July 17, 2008 at 4:54 am
What do you mean by , tables that you create locally?
Does this mean tables you have created on a local server on your machine?
Sql server operates in a client - server basis, where you should be connecting to a server hosting sql server and create tables there.
It is different from Access where the database resides locally on your machine.
July 17, 2008 at 7:26 am
Thanks for reading this, I'll try and explain more clearly.
If I am working on a web site and want to incorporate a database I will create the site and files locally and create some dummy data to test it all, then when I am happy that its working I want to upload it to the hosting web server.
Are you saying that I have to recreate the database on the hosting server, after I already created it on my local testing server?
July 17, 2008 at 7:33 am
Once you have created it locally and are happY with it, then you will have to re-create it on the hosting server.
If you are only interested in moving the database structure and not the data then, this can be easily done by generating a script for your database and then running this on the production server.
Right click on the database in SSMS and select Tasks-->Generate Scripts
follow this wizard, and this will generate a complete script that you can run on the remote server to recreate your database.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply