Red Gate forums :: View topic - "Object reference not set to an instance of an object" Error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

"Object reference not set to an instance of an object" Error

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JackLocke



Joined: 13 Jun 2012
Posts: 17

PostPosted: Thu Jan 16, 2014 8:59 pm    Post subject: "Object reference not set to an instance of an object" Error Reply with quote

Hi All,
I just ran into some really strange error today while trying to prepare update with SQL Packager 6.4

I have two databases and I want to create database update based on difference between them. But, when I run SQL Packager via CLI, I get following error after a step where databases get compared.

Quote:
Registering databases
Mapping
Comparing databases
Error: Object reference not set to an instance of an object.


But if I use UI and do same thing, it finishes without any issue and it generates update exe.

Any suggestions ?

TIA,
Jack
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Mon Jan 20, 2014 12:16 pm    Post subject: Reply with quote

I'd say based on this and your later email, the most likely issue is a lack of permissions to all of the object in the database schema.
Back to top
View user's profile Send private message
JackLocke



Joined: 13 Jun 2012
Posts: 17

PostPosted: Mon Jan 20, 2014 2:45 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
I'd say based on this and your later email, the most likely issue is a lack of permissions to all of the object in the database schema.

I am running this script as SA. So I am sure it has permissions for all objects.

Following is the command that I am using,

Code:
"C:\Program Files (x86)\Red Gate\SQL Packager 6\SQLPackager.exe" /db1:"NEW_DB" /u1:"sa" /p1:"password" /s1:"(local)\SQLEXPRESS" /db2:"OLD_DB" /u2:"sa" /p2:"password" /s2:"(local)\SQLEXPRESS" /location:"C:\test" /name:testEXE /makeexe /includedata:table:\[Version\] /verbose


TIA
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group