I am a new member in ure forum and also a new in sql server 2005 and sql server managment studio,, I create a web site with sql server 2005 express then I want to upload it but I face a problem while upload the database file they tell me that I should create the database in the hosting server then build the tables and fields then import csv file for each table is this mean importing data using csv file and how I could do it using sql server managment studio.
You can use BCP command to save the data from a table to a file. There are some good examples on this page http://msdn.microsoft.com/en-us/library/ms162802(v=sql.105).aspx If you are using SQL Express, your servername would be (local)\SQLExpress or Servername\SQLExpress
You can use BCP command to save the data from a table to a file. There are some good examples on this page http://msdn.microsoft.com/en-us/library/ms162802(v=sql.105).aspx If you are using SQL Express, your servername would be (local)\SQLExpress or Servername\SQLExpress
I can select data from each table then save them as csv file then import them into the table which be in hosting server since I havent sql server managment studio standard edition
Yes, you can do that one file at a time. You can run BCP commands from a command line one at a time, or you can put the commands for all the files into a single cmd file and run that cmd file.
about csv file
Posted - 02/04/2013 : 02:18:53
