795
Hi,
I have a view with some fields and i want to dump the whole data of all those fields from a view in a SQL table for the fields correspondingly mapped to it.How to start with it using C#?
Thanks for any help!
*This post is locked for comments
Sir, my requirement is to dump view data kept in a remote server to my local db table with the help of SQL script..Can't do using Excel export . Can you help for establishing connection between two servers?
According to my understanding, you want to Dump data from CRM to your MS sql, If my understanding is correct.. please follow below step
1) Go to the view for which you want to dump data Export that file in excel
2) And step by step follow the below link, it will help you in dumping data into MS sql database
https://solutioncenter.apexsql.com/how-to-import-and-export-sql-server-data-to-an-excel-file/
Thanks,
Shahbaaz
Can you please elp me from scratch that if i don't know anything about SQL jobs, how do i write a SQL job ?
Hi,
Make sure your both the connection string name are different also check below link .
stackoverflow.com/.../multiple-sql-server-connection-strings-in-app-config-file
www.codeproject.com/.../How-to-get-Connection-String-from-App-Config-in-Cs
If it don't resolve your issue post your app config file.
Thanks,
Shahbaaz
Sir, can you help me out for one doubt->
I am using two connectionStrings in my app.Config .
1. From where data is retrieved 2. To where i ant to save the retrieved data
Then , always its pointing to a single connectionString.How do i specify when to point to where? That's y i am getting Invalid objects
Please check below link,
stackoverflow.com/.../sql-server-invalid-object-name-but-tables-are-listed-in-ssms-tables-list
if you solved the problem thanks to an answer,
please mark it as verified to encourage the community to provide more and more a better support.
Thank you.
Shahbaaz
Thanks ..One more doubt..If i am able to retrieve view data using C# code and gave two connectionstrings -> one for retrieving data from one server and one of where we want to store that retrieved data.
But, now i am getting "Invalid Object Name: table_name"
Also you don't require any code in this.
Hi,
You can export that view in excel file and than you can import that excel file into your SQL database.
check below link to import data into database
www.mssqltips.com/.../simple-way-to-import-data-into-sql-server
docs.microsoft.com/.../import-data-from-excel-to-sql
Thanks,
Shahbaaz
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
