Red Gate forums :: View topic - How do you connect Multi_script to a CE database.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

How do you connect Multi_script to a CE database.

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
johnc650



Joined: 05 Feb 2008
Posts: 10

PostPosted: Fri Apr 17, 2009 12:09 am    Post subject: How do you connect Multi_script to a CE database. Reply with quote

I was reading this article about reading the windows CE database using multiScript.. http://www.sqlservercentral.com/articles/Backup/61968/.

One thing it did not explain was how to connect to a CE database with MultiScript..

I don't see any way to connect anything but a normal sql database... Am I missing something??

-jfc-
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Fri Apr 17, 2009 11:32 am    Post subject: Reply with quote

Hi John,

SQL Multi-script supports Microsoft SQL Server databases only -- it currently doesn't have CE or ODBC capability. The theme of the article that you linked to was about how to retrieve backup history from a SQL Backup data repository, which is a SQL CE database, but is being accessed via T-SQL queries that are sent to a SQL Server.

These queries use the sqbdata extended stored procedure, which is getting the SQL CE data from the repository and feeding the results through the MS SQL connection.

So aside from querying SQL Backup activity history, this is not a method that you can generally use to connect to any CE database and query it.

I hope that this clarifies things.
Back to top
View user's profile Send private message
johnc650



Joined: 05 Feb 2008
Posts: 10

PostPosted: Tue Apr 21, 2009 6:43 pm    Post subject: SQL CE... Reply with quote

Ahhh got it now... Did not realize it was running the sqbdata out of master db..

Thanks,

-jfc-
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