First of all, nonono, please don't do that, you must NOT have different DB in DEV and PROD.

Second, if you still want to do that, then you should review all your Connect SQL rules. They could be DBprovider specific. And in future, never write custom Connect SQl rules.

And, the last.. It's simple - Just DON'T DO THAT. You will never be sure that your code you're going to deploy on prod will work.

Also if you manage to move data to different DB, you would need to do extensive testing in PROD as well.

Hi

As mentioned in other comments, its a definite NO for such a setup.

Would really be interested to know why do you want to go for this?

Regards

Bhavya