N/APosted on - 08/19/2011
I have imported one batch in SQL server based application but there was some problem in that batch which was not recognizable at that time, so it is imported but not all the data into their respective tables.
Now just suggest me the solution to import the remaining data. I have imported it on the backup server then, by exporting the table technique.
I have made a notepad file of data but not importing properly into the actual server.
Exporting/Importing files into the SQL server tables
Importing tables in the databases is not a difficult part of this process but importing tables with data, is something that needs more consideration and care when you are processing. I suggest you perform the tasks one by one and let me know if the problem is still there.
1: Open SQL
2: Select the Database in which you want to import the data.
3: Right click on any table of the selected database.
4: Click on “All Tasks”.
5: Select “Import Data”.
6: Click “Next”.
7: In Data Source select “Microsoft OLE DB Provider for SQL Server” from the drop down list.
8: In “Server” select “Local” or your target server.
9: If you are using windows authentication then select “Use windows authentication”.
10: Otherwise select “Use SQL Server authentication” and give SQL username and password.
11: In Database Select the database from which you want to import the tables with data.
12: Press “Next’.
13: In Destination process, select the Data Source, Server, and Authentication Mode as described earlier.
14: In Database Select the database to which you want to import the tables with data.
15: Select “Copy Tables and views from the source database” option.
16: Press “Next” button.
17: Select the table(s) from the list of the tables and views of source database.
18: Press “Next” button.
19: Press “Finish” button.
20: Press Refresh button given on the SQL panel or select it from the file menu.
After this you can checkout that tables are imported with data as well.