Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Abid
110 Posts |
 Posted - 2014-10-15 : 22:54:18
|
| Hi. I developed a project in vb.net and sql server enterprise 2008. My project is completed and now ready to deliver. But I have a problem. Every time i deliver project to client so i need to install a heavy sql server 2008 software on his machine which seldom slows the client computer. Isn't there anyway by which I do not install the sql server on his computer or If it is necessary to install then can i install sql express on client computer. I mean that attaching my .mdf to sql express will fullfil all my requirements or not?Or I'm bound to install sql server 2008 on his computer?Thanks. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-10-16 : 04:06:58
|
| you should have the database and application installed on a separate server which should have connectivity with your clients computer.Javeed Ahmed |
 |
|
|
Abid
110 Posts |
Posted - 2014-10-17 : 12:28:14
|
quote:
Originally posted by ahmeds08
you should have the database and application installed on a separate server which should have connectivity with your clients computer.Javeed Ahmed
Javed Bhai this app will be running on a standalone PC. What I"m asking is that if i install express edition on his computer so can i attach my .ldf and .mdf with express edition? and will it be working fine? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-17 : 12:43:21
|
| Yes you can attach the files to his Express edition instance, but whether or not it'll be working fine depends on the steps you take. You may need to unorphan the users with the logins.The installation of SQL Server should not slow his computer down. If it is, then it's likely due to the database and not the actual installation. Or it's a hardware resource issue where he doesn't nearly have enough memory.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Abid
110 Posts |
Posted - 2014-10-17 : 12:54:27
|
quote:
Originally posted by tkizer
Yes you can attach the files to his Express edition instance, but whether or not it'll be working fine depends on the steps you take. You may need to unorphan the users with the logins.The installation of SQL Server should not slow his computer down. If it is, then it's likely due to the database and not the actual installation. Or it's a hardware resource issue where he doesn't nearly have enough memory.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
Tara, if this is the issue that then its all right. I'm going to install the actual sql server on his machine.Ok would you guide me also or refer me to some link for how to install my app on server and then access it on client. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-17 : 12:57:45
|
| I can't help with installing your app as I have no idea what it entails. I can help with SQL Server-related questions.You should be aware of the Express edition limitations and make sure that it suits the needs of your app.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Abid
110 Posts |
Posted - 2014-10-17 : 13:13:36
|
quote:
Originally posted by tkizer
I can't help with installing your app as I have no idea what it entails. I can help with SQL Server-related questions.You should be aware of the Express edition limitations and make sure that it suits the needs of your app.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
I said I"m not using express anymore. I'll be using sql server enterprise edition. guide me for that. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-17 : 13:35:22
|
| Which part do you need guidance on? The installation is basically the same. There's no difference in attaching the database or setting up logins. Most of the difference between the editions are features, where Enterprise will have things and Express won't. But that shouldn't matter to what you've posted in here.Are you licensed to use Enterprise? It isn't cheap. Based on what you've posted in here and not knowing anything else, I would have thought you'd use Express or Standard edition. Enterprise seems excessive, but you'll need to provide more info.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Can i change my database to Express edition