Hi,
I have a database on a sql server 2005, and I would like to migrate data from sql server 2005 to local Pocket PC. How can I create a database on local Pocket PC and how to migrate the data from sql server 2005 to local Pocket PC? The operating system on Pocket PC is Microsoft® Windows Mobile„¢ 2003 Second Edition. Thanks in advance.
Hello:Does Sql Server 2005 Express support data migration from Sql Server 2000.
View 2 Replies View Related
Hi,
I am developing an application for pocket pc 2003 smart device which utilizes synchronization between SQL CE 2005 and SQL server 2005 by means of REMOTE DATA ACCESS method call PULL( ) and PUSH( ) but currently these are the details of the error Im encountering when PULL( ) method is called:
Error code: -2147467259
Descripion: An error occured on the computer running IIS.Restart the IIS server.
Minor error: 28022
Source: SQL server CE
Currently Im developing this application as a final project and due to some limitations I have setup my pc to act as the SQL server and the IIS server both on the same machine.
Any help will be appreciated, thanks.
how do i connect to sql server with pocket pc2003 se emulator.it gives me the sql exception all the time.i tried to install virtual machine network adapter but result is same.Am i missing something?
Thanks in advance
Hi,
I am a total beginner to Pocket PC, and a 2-month beginner to SQL Server 2005 and Visual Studio 2005. I made a database Pillbox.mdf, and wrote a Windows Forms program to access it. It's really easy. I just added a Data Source, chose tables and Stored Procedures, and dragged them onto my forms. It automatically created adapter classes and a DataGrid for me.
Next, I wanted to do the same thing for Pocket PC. I did the same drag and drop thing, and was happy to see the empty DataGrid in the emulator (design-time) form. From here on, trouble. When I ran it, it said it could not connect.
So some questions:
1) Does my connection string have to change? It has 3 parts: machine name, database name, and security spec. It specifies my machine name. Is that ok? Is it known by the Pocket PC, or do I have to specify http something? Does my machine have to change any settings to become a "server"? It's just a standalone PC with no network. I understand the emulator chooses to pretend that it's not "on" my computer. Is the database name known by the Pocket PC? (Same type of question.) And is Windows authentication ok on a Pocket PC? Or must I create a name/password pair on SQL server?
2) When I went to modify my connection string, I noticed a setting to specify the Data source. For SQL Server 2005, it asks me for a dbo, but for SQL Server Mobile, it asks me for a *.sdf file. What type of file is this? Is there a way to generate this from my other database? Is it not possible to have the the Pocket PC app point to the same database as the Windows app? Oh... does the sdf represent the Pocket PC's local database? If so, then my question is just how to populate it. But I will also have to update the main database at some point. I guess I'm confused about how Pocket PC's are supposed to work.
3) Do I have to deploy SQL CE or something? I think I read that Visual Studio does it automatically. It's a bit hard reading blogs because many comments talk about things that are now contained in VS. One blog was talking about 7 dlls that need to be downloaded to the Pocket PC.
4) My application just has to get a table, store it on the Pocket PC, and allow the user to modify and update records. The bandwidth should be low, as the table is small and updates should not be frequent. Is this a reasonable design? What I am asking is if it's ok to have direct database access, or if I should package up the data in some custom format, and use a Web service to pass the data back and forth. I have read and understood articles why you should not pass a Dataset in a web service, but the point was just that web services can be interoperable, so why spoil that with MS-only Datasets. In my case, I just want to get this simple app up and running quickly.
Thanks in advance.
Hi. I have a problem. I'm working at the moment on application witch should write and read data from sql server. The application should work on windows mobile devices. I'm linking this code to event on a button:
Code Block private void menuItem1_Click(object sender, EventArgs e)
{
SqlConnection sqlCon;
sqlCon = new SqlConnection(String.Format(@"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
@"192.168.54.149sqlexpress", "MojDom", "kuba", "abuk"));
sqlCon.Open();
string insertString = @"insert into {0} values ('{1}', {2})";
SqlCommand cmd;
cmd = new SqlCommand(string.Format(insertString, "MojDom", "Kuba", 15), sqlCon);
cmd.ExecuteNonQuery();
if (sqlCon.State == ConnectionState.Open)
sqlCon.Close();
}
and on line sqlCon.Open() i get exception:
Code Block
System.Data.SqlClient.SqlException was unhandled
Message="SqlException"
Class=20
LineNumber=0
Number=6
Procedure="ConnectionOpen (Connect())."
Server="192.168.54.149\SQLEXPRESS"
Source=".Net SqlClient Data Provider"
State=0
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError()
at System.Data.SqlClient.SqlInternalConnection.OnError()
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at AIHouse.FormMain.menuItemSettings_Click()
at System.Windows.Forms.MenuItem.OnClick()
at System.Windows.Forms.Menu.ProcessMnuProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at AIHouse.Program.Main()
And when im using exactly the same code in windows console application everytihng works fine when i run it on pc with sql server and emulator, or other pc connect to network. I'm working on emulator of Pocket PC 2003, I've "put" it in cardle and the emulated device has connection to my pc and internet, the firewall is off.
I really dont have any idea why it's not working.
sorry for my english, but its not my foreign language.
thx for sugestions and reply.
regards Kuba
I asked this question on another forum, and it was suggested that using SQL Server might be the way to go.
What I would like to do is create a database that can store detailed employee payroll information for workshop production. Included in this db would be employee info, job details, hours worked, pay rate, and so on and so forth. That will probably be the relatively easy part.
I would like to allow supervisors (job coaches) to enter this data on a Pocket PC (windows mobile) device, and then be able to synchronize the pocket pc to a workstation, allowing their data to be uploaded to the main database at the end of the day.
Can that be done using SQL Server as both the main networked database as well as having it (or a lite version of some sort) installed on a Pocket PC for synchronization purposes as described above?
Thanks for any input.
I am trying to use a new Excel microsoft add-in using SQL server 2005. I installed the 180 day trial version of SQL Server 2005 on my local machine and according to the instructions it was suppose to be very easy to connect the excel add in to SQL. I am receiving an error message which I cannot find a resolution to using the readme file and wonder if you can help.
ERROR MESSAGE
Unable to connect to server 'localhost'. Please make sure user 'ARTIMUS' has at least read permission to some database on the server.
THanks for your help!
Art
Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL. Any help would be greatly appreciated.
Device Env:
Windows Mobile 5.0 + Messaging and Security Feature Pack
SQL Server Mobile 2005.
Merge replication works fine without SSL. After running the Configure Web Sync wizzard to setup SSL merge replication no longer works. Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine. There was no prompt saying the cert was bad etc.
The certificate is a:
Equifax secure global ebusiness CA-1 cert.
Signature algorithm md5RSA
public key RSA(1024 bits)
thumbprint algorithm sha1
Stacktrace given is:
- ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException
- Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
Count 1 Integer
Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. System.Data.SqlServerCe.SqlCeError
HResult -2147012858 Integer
InnerException Nothing System.Exception
Message "A request to send data to the computer running IIS has failed. For more information, see HRESULT." String
NativeError 28037 Integer
Source "Microsoft SQL Server 2005 Mobile Edition" String
StackTrace "at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()
at System.Data.SqlServerCe.SqlCeReplication.Synchronize()
at MyApp.Helper.Replication.SynchronizeInit()
at MyApp.CallSynchronize()
at System.Windows.Forms.Control.OnGotFocus()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.ContainerControl.WnProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at MyApp.Program.Main()
i am using C#..net
I am synchronizing the sql server data with sqlce.but i get an
error when i call synchronize function. i am using sqlcereplication
class.
the error is
"a call to sql server reconciler failed"
native error 29006
and sometimes
native error
29045.
Hi Everybody,
does anyone know how I can migrate SQL 2000 data to SQL 2005 database? I'm trying to create an application that will connect to SQL 2000 database using VS2003 and transfer data to SQL2005 database but it doesn't seem to work. Any suggestion is greatly appriciated.
devmetz.
whats the simplest way to migrate a user account from a master development SQL server to local development sql servers and also to a production server?
we can recreate the SQL account everywhere, but if we take a backup from one machine and restore to another, we loose access because the accounts arent truly the same account.
Do you now, How can I move database with datas to release version of sql server?
Procedores backup/restore can't help becouse of unsuported version database.
Any ideas?
I have right clicked on my DTS package and selected Migrate... Iassumed this is a good idea for future upgradeability (?) The processworked without error but I have no idea where the resulting migratedpackage can be found. The DTS package itself (apparently) remainsunchanged.If your answer is that an SSIS package has been created, please tell meexactly where I can find it.I've looked at SQL Server Business Intelligence Studio (where do theyget these names from?) and have not been able to find SSIS (or anythingelse useful, actually).
View 5 Replies View RelatedHello Everyone,
We have a need to migrate some DB2 servers to SQL Server 2005. Unfortunately, the SSMA for DB2 is still not out. Can anyone please tell me on what are the things to consider with regards to DB2 to SQL 2005 migration? It would help if you can point me to some whitepapers or tools ir maybe even some samples or instructions regarding the migration. Thanks!
Regards,
Joseph
Hi All
Newbie to SQL CE 2005. We have an SDF database file with a whole bunch of tables and data. We have to port the SDF to SQL Server 2005 database. The SQL Server DB is empty has no knowledge of the SDF tables/schema. How do I go about to get the SDF schema/tables migrated to SQL Server DB and then also transfer the data.
Thanks
Kris
helloi am working on a mdf file on sql server express 2005 and i would like to migrate the content to sql server 2005.How can i do it ?
View 3 Replies View RelatedHello. I have the following problem. I have a database in mysql and i want to migrate in ms sql server 2005. How can i do that? I have downloaded and installed MySQL Connector/ODBC .
View 8 Replies View RelatedHi SQL Team,
Data migration from MS access to Sql server 2005.
In client having existing system is MS Access. So I want to migration MS Access system to SQL server 2005.
Let suppose there MS Access one table having 10 fields.
That table data i need migrate in system (sql server 2005), but the field name are different & sql server few fields are extra suppose 15 fields or vise versa.
So can any one help me out, how to migrate the MS access to sql server system?
Please give me if any one the script or step do this.
Thanks & regards
I am trying to convert an Access database to SQL Server 2005. I have gotten the tables imported into SS2005 but how can I get all my queries imported in? Or is it not possible? Thanks.
John
Hi - is it possible to migrate to SQL Server 2005 Express from MSDE - and still use ASP.Net 1.1? Or will Express only work with ASP.Net 2.0?My MSDE database has simple SPs (no functions), and straight forward tables - can I just use DTS from Enterprise Manager to transfer this from MSDE to SQL Express, or create a backup, and import that into SQL Express 2005?Also, there was a sort of Enterprise Manager available for SQL Server 2005 Express at one point - does anyone know where to find that?Thanks for any pointers/help.Mark
View 4 Replies View Relatedhi.
I have a question. I work in BI (with sql server 2000) and this year (2008) my idea is migrate to 2005, but, consulting to expert in Microsoft technology, they suggested wait to 2008, sql 2005 have many problem, sql server 2008 was completed re-write.
The question is, what problem have sql server 2005?
TIA.
Abel.
I have a database in MS Access that I would like to migrate to SQL Server Express 2005. How do I do this? Is there a software I need to download?
View 4 Replies View RelatedHi All,
We will replace our website which currently build in php and mysql into .net and sql server 2005. What is the best way to migrate all the user account from current database in mysql into sql server, also considering that there is different database table and fields?
Thanks in advance.
Hi All,
I have to migrate SQL Server 7.0 data to SQL Server 2000. How to go about doing this migration. What are the steps? Any pre-requisit before doing the migration?
Is there any book or KB articles or White paper on this topic on the net.
Appriciate any help on this issue.
Thanks
Sri
Hi All,
I have to migrate SQL Server7.0 data to SQL Server 2000. How to go about this migration? What are the steps and pre-requisit?
Is there any books or KB articles or White papers on migration from 7.0 to 2000
Appriciate any help on this issue.
Thanks
Sri
Hi to all,
I m a new DBA
I have a problem
I have a SQL Server with 300 Databases on a machine.
Now company has bought new Machine
How to migrate data from old server to this new machine
without recreating logins
can some one help
Thanks in advance
I plan to migrate a SQL 2000 instance with everything in it to another SQL2000 server, and eventually in the future to SQL 2005.
I've pretty much figured out how to migrate everything execept the linked server configuration (there're many linked servers configured in the old server with different security credentials). I'm wondering if there's way I can save the linked server configuration and restore it to the other server.
Thanks much.
Ed
I have a SQL server 2000 database.I have to migrate it to SQL Server 2005 Express.But I don't know how to do.
Is any one can help me ?
Thanks
In my application,I used Sql Server 2000 Database where I used some Stored Procedures,View,Function and Triggers .Now I want to migrate it to Sql Server 2005. Is there any performance issues will come in future as the database is actually from SQL SERVER 2000? Is all these Stored procedures,Views,Function and Triggers will work perfect? If than what steps I have to take to over come them.
View 1 Replies View Relatedhi guys,
I have created data-driven subscriptions on top of the existing reports on my development server.
I have same reports on QA's report server but without the DD subscriptions.
Is there an easy way to migrate data-driven subscriptions to QA report server or the only way to do is create each subscription manually?
Thankskev
I currently have SQL SERVER 2000 Running. Once I upgrade that 2000 server to 2005, how do I migrate the dtspkgs that were on 2000 TO 2005?
We have DTS packages in SQL Server 2000, which populates the data from SQL 2000 to Ms-Access tables.
We are moving our database from SQL Server 2000 to SQL Server 2005.
Why & How & What is the best approach to migrate DTS packages?
Migrate SQL Server 2000 DTS to SQL Server 2005 DTS Or SSIS