Insert data to multiple tables

(0) Share

Report

Posted on by CRM Beginner

795

Hi,

I have a view in different database and three tables to different database.I want to insert view data to all these tables to their corresponding columns at once.

Can you please suggest me a way?

*This post is locked for comments

All responses (9)

Answers (1)

Verified answer

Aric Levin - MVP 30,188 Moderator on at

Like (0)

Report

RE: Insert data to multiple tables

If as Mahen is asking, if your question is regarding creating a SQL Server view and has nothing to do with CRM, you should definitely post this in the SQL Server Forum.

Regardless, you can go to SQL Server, expands views, create a new view and use the designer to establish the relationships between the three tables.

Simply add the tables using the designer and drag and drop.

Hope this helps.
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

RE: Insert data to multiple tables

You could export the data from CRM into excel and then use SQL Server Import/ Export Data wizard to import the data.

Check these links-

www.mssqltips.com/.../simple-way-to-import-data-into-sql-server

searchsqlserver.techtarget.com/.../The-SQL-Server-Import-and-Export-Wizard-how-to-guide

Hope this helps
Mahendar Pal 45,095 on at

Like (0)

Report

RE: Insert data to multiple tables

Assuming you are talking about non CRM custom tables and as this is SQL specific question, I will suggest you to post your question to SQL server forums to get quick response.
CRM Beginner 795 on at

Like (0)

Report

RE: Insert data to multiple tables

I am using SQL Server..basically i have a view in Sql ..And i want whole view data to get split in three tables in SQL Server
Mahendar Pal 45,095 on at

Like (0)

Report

RE: Insert data to multiple tables

what do you mean by multiple table ? which environment you are using ? share some more details
CRM Beginner 795 on at

Like (0)

Report

RE: Insert data to multiple tables

For inserting data in CRM is done using my entity framework, i just simply want to execute SQL query for now which will dump View data to multipl tables
Mahendar Pal 45,095 on at

Like (0)

Report

RE: Insert data to multiple tables

Executing insert SQL query against CRM db is not supported , even though it's possible technically in on premise, and you used online tab in your question, so I am assuming you are using online where you don't have access to DB

That's why I suggest to use SDK

Please let me know if my understanding is not correct?
CRM Beginner 795 on at

Like (0)

Report

RE: Insert data to multiple tables

Sorry, I think u mistaken my question..I want to write write SQL Query to send View data to three tables at one go
Mahendar Pal 45,095 on at

Like (0)

Report

RE: Insert data to multiple tables

You can use CRM SDK to insert data to multiple entity. Download SDK you can get sample code there.