How to Regenerate Staging Table

(0) Share

Report

Posted on by Tony zhong

903

Hi,

If we delete physical object of staging table in SQL, can we generate it again in Visual studio ?

I delete it, but in Visual Studio project still there, but failed on Synchronize table. I tried to open Data Entity and right cilck to Regenerate Staging Table option, it didn't do anything.

Thanks,

I have the same question (0)

All responses (14)

Answers (1)

Sort by

Verified answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

You need to cleanup record in sqldictionary table, first find table id by entity name and then delete all records with this table id from it.

Was this reply helpful? Yes No
Tony zhong 903 on at

Like (0)

Report
Copy link

Link copied!

Hi where can I find this table ?

Was this reply helpful? Yes No
Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can query this table using SQL server management studio on dev VM.

Was this reply helpful? Yes No
Tony zhong 903 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

Well, 1st of all, I deleted it from SQL management studio. In hope, Visual Studio will recreate it, but it did not.

So I go to Regenerate Staging, while actually I can see the staging table object in my Project, even I can see it in AOT. But nothing happened,

Thanks,

Was this reply helpful? Yes No
Tony zhong 903 on at

Like (0)

Report
Copy link

Link copied!

Hi Sukrut,

Did you mean the sqldictionary table ? ok so can advice how am I going to find it ?

Thanks,

Was this reply helpful? Yes No
Martin Dráb 240,312 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

"Regenerate staging table" generates application objects, therefore it's not related to your problem.

The process that reads application objects and creates corresponding elements in database is database synchronization.

Yes, Sukrut was answering your question about where you can find SqlDictionary table.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,097 on at

Like (1)

Report
Copy link

Link copied!

Hi Tony

If you run full sync. from VS you will see the message in the log from DroppedTableValidator with the list of tables. The log message has information about SQL stored procedure which should fix the issue: EXEC SP_REMOVETABLE "table_name". It will do the same steps as Ievgen mentioned in the first post. After you run this stored procedure in SQL you need to perform sync. operation in VS.

BR, Sergey

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Tony,

When you manually delete the staging table in SQL, you return to VS, you can Regenerate Staging Table, and then it will appear in your project. But at this time, database errors will be synchronized, I think this should be the difficulty encountered.

-

My solution is to manually create a staging table with the same name through a statement in SQL, and add the required fields of not null, then you can synchronize the database normally, build project.

-

Take my table MySelectTable as an example, when you delete MySelectTableStaging, regenerate it in VS, and then create it through SQL statements, and add some not null fields?

Was this reply helpful? Yes No
Tony zhong 903 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Thanks for more information. But the synchronization is failed because probably the "physical" table is deleted. So it is confusing, what should I do first ?

The Application object as you're saying, is still there and correct the way I see it, but now the table in database is gone. Build is completed but Synchronize is failed. When it is failed, it won't create any object in SQL DB it self, am I right to say that ?

Btw I found the SQLDictionary table, so as advised, I must delete the field id record (rows) of that table ?

Thanks,

Was this reply helpful? Yes No
Martin Dráb 240,312 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Yes, I understand your situation, I was just explaining why regenerating staging table can't fix your problem.

You've already got replies explaining what you should do.

Was this reply helpful? Yes No