|
Simple problem. I have an SQL Server database (MyData.mdf) and I want to convert it to a Compact database. (MyData.sdf) Just can't find the proper tool which can do this for me.
And I would also be able to convert the compact database back to a regular...
Started by Workshop Alex on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You might consider using SQL Server Integration ....
Have you tried any hidden options from SQL Server Studio?
They aren't directly convertible from one to the other; many aspects of SQL Server aren't supported in SQL Compact.
|
|
Hi,
I'm just wondering what's the difference between a SQL database snapshot and a regular SQL database? Can someone out there would like to help me understand the difference between the two?
Thanks in advance.
Started by KG Sosa on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Any changes to the original database cause the version of the data when the snapshot was taken to get written to the file for knowing exactly what your database....
A snapshot is a read-only copy of another database, made at a point in time.
|
|
I'm trying to decide what database system to use for my next project which will be using VS.NET 2008 and will likely have a bit of LINQ code in it. No LINQ support may be a dealbreaker for any database system. Is DB_LINQ mature enough to allow other DBMS...
Started by brian on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Many....
If I needed a true OR/M solution using DBLinq for production code.. .
Well there shouldn't be any problem using Linq to SQL for your OR/M needs.
LINQ to Entities works just fine with many non-SQL-Server DBs.
LINQ != LINQ to SQL.
|
Ask your Facebook Friends
|
I think there is an upgrade/downgrade path between MySQL and DB2 because they are both pretty ANSI standards compliant.
Other than SQL Express, is there a similar pairing of free-"ish"/paid databases for SQL Server?
Another way to state the question--...
Started by MatthewMartin on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
That being said advantages with Sql Server....
SQLite is lacking too many functions to even come close .
If your database is big enough that a free edition won't cut it, it's big enough a lot of what T-SQL does.
SQL Server.
|
|
I am using VS 2008 Team Suite and SQL Server 2008 in my development environment. I am deploying to a shared-host website with shared-host SQL Server 2005.
I want to push changes from my development environment to my production host.
I tried using Data...
Started by James McFarland on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Once you know T-SQL backwards and forwards (every little under-the-hood or non-obvious way.
|
|
I have a SQL Server 2000 database backup, but I don't have SQL Server 2000 installed. I have SQL Server 2005 installed. I'd like not to have multiple pieces of DB server software installed. Is it possible in either SQL Server 2005 or SQL Server 2008 to...
Started by BenAlabaster on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
That means that a SQL Server 2005 SP1 will not be able to....
There is a Compatibility mode in SQL 2005 (probably 2008) that will let you run your 2k database own database format, and the format changes from version to version.
|
|
Does Microsoft's SQL Server Database Publishing Wizard work with SQL Server 2003? Just wondering because all I can find info about is 200 or 2005.
Started by garynei on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can go here to find more information....
There is a windows server 2003; but that's the OS .
There is no version like that in SQL Server? Are you referring to SQL Server 2008? Then yes, DatabaseThere isn't such a thing as SQL Server 2003.
|
|
I want to create a SQL Server Express database on my local machine and then upload it to a website that will be using the full SQL Server software - can I do this ?
Started by Ebircsa on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Both programs use the same database backup and restore Script everything manually Database publishing wizard Microsoft SQL Server DatabaseThe MS SQL Express....
Version of SQL Server, and restore the databases there.
|
|
I have 4 SQL Server 2005 db's that I want to move to SQL CE. I know I cannot keep the SProcs,Views, and Functions( Differences Between SQL Server Compact and SQL Server ) but I would like to keep everything else.
I have tried this app, SQL Server to SQL...
Started by Refracted Paladin on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Tools in management studio?
1.Use SQL Server to SQL Server Compact Edition Database Copy sql compact 3 or 3.1 on it, and convert your database inside it
2.You can convert to sql compact of the DB, then you could....
|
|
I'm desperately looking for SQL Database Publishing wizard. I've download it but it seems to require SQL Server 2005. According to http://blogs.msdn.com/webdevtools/archive/2007/10/15/sql-database-publishing-wizard-is-now-in-visual-studio-orcas.aspx it...
Started by J. Pablo Fernández on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You create a .SQL script file....
In this case we will use the Northwind database that comes with SQL Express.
The SQL Database Publishing wizard is in Visual Studio 2008:
Step 1: Create a new website to a database.
|
